Vidya Bala's Blog

Search My Blog

Add RSS Feed

Friday, September 29, 2006

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

2 Comments:

  • i think 10g as some improvments in this area .

    can you publish this htmldb application ?

    By Blogger gonen, at 1:27 PM  

  • I think so too - due to budget constraints we may a yr away from a 10G upgrade.
    Publish the Application on the internet ?? - the Application is published inhouse for Customer Specific Db monitoring

    By Blogger Vidya Balasubramanian, at 9:00 AM  

Post a Comment

<< Home