OraFAQ Forum: Performance Tuning » STATSPACK ANALYSIS TOOL

Home » RDBMS Server » Performance Tuning » STATSPACK ANALYSIS TOOL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

STATSPACK ANALYSIS TOOL [message #255477]

Wed, 01 August 2007 00:45

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Hi guys,

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

TIA,

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #255485 is a reply to message #255477]

Wed, 01 August 2007 01:00

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #255497 is a reply to message #255485]

Wed, 01 August 2007 01:21

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

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

TIA,

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #255500 is a reply to message #255477]

Wed, 01 August 2007 01:28

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #255503 is a reply to message #255500]

Wed, 01 August 2007 01:31

navaneethdba
Messages: 71
Registered: July 2007
Location: chennai

Member

Thanx a lot for ur advice..

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #263836 is a reply to message #255503]

Fri, 31 August 2007 02:47

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

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #263854 is a reply to message #263836]

Fri, 31 August 2007 03:28

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is not free.

Regards
Michel

Report message to a moderator

Re: STATSPACK ANALYSIS TOOL [message #265267 is a reply to message #263854]

Wed, 05 September 2007 23:19

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 05:57:08 CDT 2024