Home » RDBMS Server » Performance Tuning » STATSPACK ANALYSIS TOOL
icon6.gif  STATSPACK ANALYSIS TOOL [message #255477] Wed, 01 August 2007 00:45 Go to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Hi guys,

Cool I need to analyse the statspack report of my own.
Is there any free tool provided to analyse the report ?


TIA,
Re: STATSPACK ANALYSIS TOOL [message #255485 is a reply to message #255477] Wed, 01 August 2007 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Analyze? What do you mean with analyze?
Something that generates a report from the report?

Regards
Michel
Re: STATSPACK ANALYSIS TOOL [message #255497 is a reply to message #255485] Wed, 01 August 2007 01:21 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member

yes i need to analyze the report generated by the statspack.

TIA,
Re: STATSPACK ANALYSIS TOOL [message #255500 is a reply to message #255477] Wed, 01 August 2007 01:28 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Is there any free tool provided to analyse the report ?
>yes i need to analyze the report generated by the statspack.
So use the software between your ears.
Re: STATSPACK ANALYSIS TOOL [message #255503 is a reply to message #255500] Wed, 01 August 2007 01:31 Go to previous messageGo to next message
navaneethdba
Messages: 71
Registered: July 2007
Location: chennai
Member
Thanx a lot for ur advice..
Re: STATSPACK ANALYSIS TOOL [message #263836 is a reply to message #255503] Fri, 31 August 2007 02:47 Go to previous messageGo to next message
goggy
Messages: 1
Registered: August 2007
Junior Member
Hi,

you can check spAnalyzer tool designed to give you tips for your oracle statspack reports. See it here http://www.spviewer.com

Cheers

Re: STATSPACK ANALYSIS TOOL [message #263854 is a reply to message #263836] Fri, 31 August 2007 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not free.

Regards
Michel
Re: STATSPACK ANALYSIS TOOL [message #265267 is a reply to message #263854] Wed, 05 September 2007 23:19 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello navaneethdba,

I would like to suggest:
1) read this guide:
http://www.orafaq.com/forum/t/88153/0/

2) run statspack/awr in your environment and bring us the report with some initial analysis from you;
you can follow these guides below:
statspack: http://www.akadia.com/services/ora_statspack_survival_guide.html awr: http://www.oracle.com/technology/pub/articles/10gdba/week6_10gdba.html
Run the report generators for each case. Scripts are located at $ORACLE_HOME/rdbms/admin

Try to analyze by your own first.
Don't bring here just a problem to get the answer.
Show us that you are making efforts too.

Instead of looking for an automated tool (automagically)... maybe this is a good opportunity to try to understand what is going on with statspack/awr. Sometimes... problem means opportunity... opportunity to learn.

Regards,

mson77

[Updated on: Thu, 06 September 2007 11:51]

Report message to a moderator

Previous Topic: Help - Tuning query
Next Topic: Can anyone sent me the good peformance & tuning pdf file for 10g
Goto Forum:
  


Current Time: Sun Dec 11 06:27:54 CST 2016

Total time taken to generate the page: 0.09065 seconds