Home » RDBMS Server » Performance Tuning » AWR and ASH report analyze (Oracle 10g,11g,Linux)
AWR and ASH report analyze [message #618067] Mon, 07 July 2014 08:44 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

In what situation AWR and ASH report should be taken and analyze ? Can you give some brief on it?
Please do not send any link to read about it.I know something about it and want to know in what situation it should be used.

Regards,
Srini
Re: AWR and ASH report analyze [message #618069 is a reply to message #618067] Mon, 07 July 2014 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Tell us what you know.

Re: AWR and ASH report analyze [message #618070 is a reply to message #618067] Mon, 07 July 2014 08:51 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Database admin wrote on Mon, 07 July 2014 19:14
In what situation AWR and ASH report should be taken and analyze ? Can you give some brief on it?

When you want to view the performance statistics to find the bottlenecks and blah blah blah... can't write a book on it here Razz

Quote:

Please do not send any link to read about it.I know something about it and want to know in what situation it should be used.

Really? Shocked
Does it mean you have read the useful links already?
Re: AWR and ASH report analyze [message #618072 is a reply to message #618070] Mon, 07 July 2014 08:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>In what situation AWR and ASH report should be taken and analyze ?
They should be used when they contain clues about a problem in the DB being monitored.
Re: AWR and ASH report analyze [message #618073 is a reply to message #618067] Mon, 07 July 2014 08:56 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Database admin wrote on Mon, 07 July 2014 14:44
I know something about it and want to know in what situation it should be used.



You realise that statement is paradoxical?
Re: AWR and ASH report analyze [message #618074 is a reply to message #618073] Mon, 07 July 2014 09:38 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Blackswan
Quote:
They should be used when they contain clues about a problem in the DB being monitored.

What kind of problems ? Can you brief some ?

Roachcoach
Quote:
statement is paradoxical

Means when sql query is slow ?

Quote:
Tell us what you know

AWR report is taken and analyzed when there is performance problem in database.
ASH enables you to examine and perform detailed analysis on both current and histroical data often avoiding the need to replay the workload to gather additional performance tracing information.


Re: AWR and ASH report analyze [message #618075 is a reply to message #618074] Mon, 07 July 2014 09:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can you brief some ?
RTFM is as brief as I can be.
Re: AWR and ASH report analyze [message #618077 is a reply to message #618075] Mon, 07 July 2014 09:47 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Quote:
RTFM is as brief as I can be.

Can you please tell me what is RTFM ?

[Updated on: Mon, 07 July 2014 09:47]

Report message to a moderator

Re: AWR and ASH report analyze [message #618078 is a reply to message #618077] Mon, 07 July 2014 09:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Database admin wrote on Mon, 07 July 2014 07:47
Quote:
RTFM is as brief as I can be.

Can you please tell me what is RTFM ?


Read The Fine Manual
Re: AWR and ASH report analyze [message #618079 is a reply to message #618078] Mon, 07 July 2014 09:55 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Sad
Re: AWR and ASH report analyze [message #618080 is a reply to message #618079] Mon, 07 July 2014 10:00 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
My point is that if you know something about it, you can't NOT know what/when to use it.

>AWR report is taken and analyzed when there is performance problem in database.


So when do you think you use it and what for? Perhaps when there are problems reported?
Re: AWR and ASH report analyze [message #618082 is a reply to message #618080] Mon, 07 July 2014 10:21 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Roachcoach ,

Thanks for letting me know when to use AWR and i also knew it Smile .I want to know in what sitaution ASH report should be used ?
Re: AWR and ASH report analyze [message #618083 is a reply to message #618082] Mon, 07 July 2014 10:24 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
The same scenarios. It depends on what data you have available.
Re: AWR and ASH report analyze [message #618086 is a reply to message #618082] Mon, 07 July 2014 10:46 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Database admin wrote on Mon, 07 July 2014 20:51

Thanks for letting me know when to use AWR and i also knew it Smile .


Quote:

I want to know in what sitaution ASH report should be used ?


A perfect example of an oxymoron. You know when to use what, but you want to know when to use that.
Previous Topic: Shameless plug
Next Topic: How about performance using index on the column which is using in WHERE and SET clause.
Goto Forum:
  


Current Time: Thu Mar 28 15:33:18 CDT 2024