RE: parsing puzzle
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Joe A-C <jwc7744@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Apr 2010 12:22:38 -0700
Because they report instance-wide stats, they could be showing you wait events
for processes that are completely unrelated to the problems you're trying to
troubleshoot. And also since they are (usually) at infrequent intervals,
transient problems can easily be buried by other more persistent events. For
example, a session that hangs for 5 minutes blocked by another transaction's
blocking lock - this 5 minute delay could be a major problem for some business
critical function that you're trying to troubleshoot, but if you look at an AWR
report over a 1 hour interval, those 5 minutes of waiting on the blocking
lock/enqueue aren't likely to show up in your top wait events.
Regards,
Brandon
-----Original Message-----
From: Joe A-C [mailto:jwc7744@xxxxxxxxx]
Why do you say that the AWR reports are likely to be misleading?
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
