Analyzing StatsPack Reports

[skdas]

Hi,

Any article at any site or any document is availble to analyze the reports generated from STATSPACK.

Thanks..

[marist89]

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

[steeve123]

I did not read the book that you dont recommend, but im curious, why you do not recommend the book?

[marist89]

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.

[skdas]

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..?

[pando]

go to metalink and search for performance tuning, you will see at least 10 notes

[Tarry]

Or go to http://www.oraperf.com./analyze.html
to upload your file and see.