Database Performace Report
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