Skip to Main Content

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!

Database Performace Report

user6421665Apr 9 2011 — edited Apr 9 2011
Hi

We are having many Oracle 10.2.0.3 instances on Unix and Windows .

We donot have Enterprise Manager configured and we donot have licence for the diagnostic packs.

Requirement : My manager wants a Graphical Report for each database intance showing its performace details . He needs the reports monthly .*

I tried to convince him by generating AWR reports , however he said he is not satistisfied with it because its too technical . He needs something in a graphical format or a presentation format where a non technical person can easily understand some things like :

1) When was peak load on the database
2) Which Application was using most resources
3) Which Table/Object was most queried
4) Statistics in regards to Disk/Network/CPU

Actually the report should be similar or a kind of Oracle EM dbcontrol's Persormace Tab where we can see all the graphs at any point of time .

I have to create a dynamic report every month with the details mentioned above for any point of Time with in the last one month.

The resulting report can be in Excel or PPT

Any pointers or Templates to get the result is highly appreciated .

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2011
Added on Apr 9 2011
18 comments
512 views