Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Performance script help

571299Aug 7 2011 — edited Aug 8 2011

Hello fellow DBAs

I need a shell script as described below to monitor our client/in house databases.

Details:

-A requirement of a shell script to be run as a cron job to produce monthly reports using statspack tables (i assume) and not AWR feature as it is a licensable option
1) Process ids using up more than 40% of CPU;
2) Sessions/programs using up high levels (>=40%) CPU
3) Top 10 worst performing SQLs with timestamp (group by SQL text)

I need something of this sorts or on similar details to provide customer's performace details about their database. I would really appreciate if anyone can share scripts. I would be very grateful

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2011

Added on Aug 7 2011

#db, #general-database-discussions, #performance, #sql

8 comments

457 views