Hi,
Any article at any site or any document is availble to analyze the reports generated from STATSPACK.
Thanks..
Printable View
Hi,
Any article at any site or any document is availble to analyze the reports generated from STATSPACK.
Thanks..
There's an excellent discussion in http://www.amazon.com/exec/obidos/AS...roduct-details
I don't recommend http://www.amazon.com/exec/obidos/tg...glance&s=books if you want to understand the statspack reports.
http://otn.oracle.com/deploy/perform.../statspack.pdf
http://otn.oracle.com/deploy/perform...G_dialeris.pdf
http://otn.oracle.com/deploy/perform...ng_otn_new.pdf
I did not read the book that you dont recommend, but im curious, why you do not recommend the book?
It's more geared towards writing your own reports against the statspack tables. Personally, I got a lot out of the book, but I already knew how to read a statspack report.
This book only tells to get the reports from the statpack tables. But I feel if are able to analyze the reports produced by Oracle Statspack and get remedy, that will be a great.
I need some conclusive analysis of the report. Is there any other book or article on analysing of Statspack report and finding the solution..?
go to metalink and search for performance tuning, you will see at least 10 notes
Or go to http://www.oraperf.com./analyze.html
to upload your file and see.