Home » RDBMS Server » Performance Tuning » AWR Interpretation and analysis (oracle 11gr2 on linux)
AWR Interpretation and analysis [message #667009] Tue, 05 December 2017 02:44 Go to next message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
Hi Guys,

This is very common question or topic for freshers and even experienced -AWR Interpretation and analysis

apart from basic like checking wait events,sql order by different metrics and finding top queries for tuning
please share advanced level analysis techniques which could point to issue ,
for instance slowness is reported by application team,first to start confirming if its database issue or no
if its pertaining to db issue than what next

Thanks
Lucky
Re: AWR Interpretation and analysis [message #667010 is a reply to message #667009] Tue, 05 December 2017 02:59 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
"instance slowness" is meaningless. Your users need to tell you which SQLs, or business processes, are too slow. Then look at tuning the wait events (if they are waiting) or tuning the SQLs (if they are not waiting).
Re: AWR Interpretation and analysis [message #667011 is a reply to message #667010] Tue, 05 December 2017 03:16 Go to previous messageGo to next message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
Thanks John,

But in situation like
- App is saying overall for any app db response is slow

and

-DB response performance is down as load increases (if batch or other job more number of executions ) cause issue,in past same load was running smoothly
no recent changes on app or db done

how is relevance of sections of awr like load profile,time model statistic

which sections of awr to refer to finding issue cause in such scenrios
Re: AWR Interpretation and analysis [message #667014 is a reply to message #667011] Tue, 05 December 2017 03:44 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
overall for any app db response is slow
Quote:
DB response performance is down
THat is meaningless. If your users cannot tell you which business processes are too slow, you can do nothing. It is not possible to fix a problem that has not been identified.

[Updated on: Tue, 05 December 2017 03:44]

Report message to a moderator

Re: AWR Interpretation and analysis [message #667015 is a reply to message #667014] Tue, 05 December 2017 04:32 Go to previous messageGo to next message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
To ask other way

How to analyse AWR
what are important sections,what details to consider and how to use it
Re: AWR Interpretation and analysis [message #667023 is a reply to message #667015] Tue, 05 December 2017 06:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
dba4oracle wrote on Tue, 05 December 2017 02:32
To ask other way

How to analyse AWR
what are important sections,what details to consider and how to use it
If you don't know what is normal for your database & server, you won't know when results indicate a problem.

If I showed you a single AWR report, how would you decide if the database was OK or not?
Re: AWR Interpretation and analysis [message #667034 is a reply to message #667023] Tue, 05 December 2017 09:51 Go to previous messageGo to next message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
some of things may indicate issue and scope for tuning like execute to parase ratio (indication of excessive parsing low execution),this may put load on cpu
Re: AWR Interpretation and analysis [message #667117 is a reply to message #667034] Fri, 08 December 2017 02:04 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
dba4oracle wrote on Tue, 05 December 2017 15:51
some of things may indicate issue and scope for tuning like execute to parase ratio (indication of excessive parsing low execution),this may put load on cpu
Something? What's something, exactly?
Previous Topic: DB Health checks
Next Topic: Query taking 20 minutes in Production
Goto Forum:
  


Current Time: Fri Mar 29 02:31:10 CDT 2024