OraFAQ Forum: Performance Tuning » AWR and ASH report analyze

Home » RDBMS Server » Performance Tuning » AWR and ASH report analyze (Oracle 10g,11g,Linux)

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

AWR and ASH report analyze [message #618067]

Mon, 07 July 2014 08:44

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

Report message to a moderator

Re: AWR and ASH report analyze [message #618069 is a reply to message #618067]

Mon, 07 July 2014 08:51

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

Senior Member
Account Moderator

Tell us what you know.

Report message to a moderator

Re: AWR and ASH report analyze [message #618070 is a reply to message #618067]

Mon, 07 July 2014 08:51

Lalit Kumar B
Messages: 3171
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?

Does it mean you have read the useful links already?

Report message to a moderator

Re: AWR and ASH report analyze [message #618072 is a reply to message #618070]

Mon, 07 July 2014 08:54

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

Report message to a moderator

Re: AWR and ASH report analyze [message #618073 is a reply to message #618067]

Mon, 07 July 2014 08:56

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?

Report message to a moderator

Re: AWR and ASH report analyze [message #618074 is a reply to message #618073]

Mon, 07 July 2014 09:38

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.

Report message to a moderator

Re: AWR and ASH report analyze [message #618075 is a reply to message #618074]

Mon, 07 July 2014 09:42

BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal

Senior Member

>Can you brief some ?
RTFM is as brief as I can be.

Report message to a moderator

Re: AWR and ASH report analyze [message #618077 is a reply to message #618075]

Mon, 07 July 2014 09:47

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

BlackSwan
Messages: 26759
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

Report message to a moderator

Re: AWR and ASH report analyze [message #618079 is a reply to message #618078]

Mon, 07 July 2014 09:55

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Report message to a moderator

Re: AWR and ASH report analyze [message #618080 is a reply to message #618079]

Mon, 07 July 2014 10:00

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?

Report message to a moderator

Re: AWR and ASH report analyze [message #618082 is a reply to message #618080]

Mon, 07 July 2014 10:21

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 ?

Report message to a moderator

Re: AWR and ASH report analyze [message #618083 is a reply to message #618082]

Mon, 07 July 2014 10:24

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

The same scenarios. It depends on what data you have available.

Report message to a moderator

Re: AWR and ASH report analyze [message #618086 is a reply to message #618082]

Mon, 07 July 2014 10:46

Lalit Kumar B
Messages: 3171
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 .

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.

Report message to a moderator

Previous Topic:	Shameless plug
Next Topic:	How about performance using index on the column which is using in WHERE and SET clause.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 28 16:50:46 CST 2021