DON’T JUST COLLECT STATSPACK DATA – PUT THEM TO USE

If your organization is collecting statspack data, don’t just print spreport when you have a performance problem and expect to have the report help you solve all your problems. If you snapshot at frequent intervals through the day – Statspack data has a wealth of information. You can plot trends for specific wait events and through consistent tuning effort you can see your wait events comedown…………………..get more for the data you collect. The below monitoring application was developed just through sql scripts against perfstat schema and using Oracle HTML DB