| AWR Interpretation and analysis [message #667009] |
Tue, 05 December 2017 02:44  |
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  |
John Watson
Messages: 8963
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 |
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 |
John Watson
Messages: 8963
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 #667117 is a reply to message #667034] |
Fri, 08 December 2017 02:04 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
dba4oracle wrote on Tue, 05 December 2017 15:51some 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
