RE: Database Time Spent Waiting (%)

  • From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
  • To: "'sidi.bouzid.meknessy@xxxxxxxxx'" <sidi.bouzid.meknessy@xxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>, "'oracle-rac@xxxxxxxxxxxxx'" <oracle-rac@xxxxxxxxxxxxx>
  • Date: Fri, 15 Jul 2011 13:29:40 -0400

These should clear automatically when the threshold is no longer crossed.

Thanks,
Finn

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of mek s
Sent: Friday, July 15, 2011 12:14 PM
To: oracle-l@xxxxxxxxxxxxx; oracle-rac@xxxxxxxxxxxxx
Subject: Database Time Spent Waiting (%)

In My RAC 11.2.0.2.2, I have the following warnings in the 
dba_outstanding_alerts,
How to clean them? I don't have Diagnostic Pack licensed for this environment; 
it's a test environment; I just have a basic license

REASON

----------------------------------------------------------------------------------------------------

METRIC_VALUE MESSAGE_TYPE TO_CHAR(CREATION_TIME,'DD-MON

------------ ------------ -----------------------------

HOST_ID

----------------------------------------------------------------------------------------------------

Metrics "Database Time Spent Waiting (%)" is at 34.11247 for event class 
"Concurrency"

  34.1124716 Warning      15-JUL-2011 17:49:32

db03



Metrics "Database Time Spent Waiting (%)" is at 76.9712 for event class "Other"

  76.9712048 Warning      15-JUL-2011 17:53:00

db02
>>> This e-mail and any attachments are confidential, may contain legal, 
>>> professional or other privileged information, and are intended solely for 
>>> the addressee.  If you are not the intended recipient, do not use the 
>>> information in this e-mail in any way, delete this e-mail and notify the 
>>> sender. CEG-IP1

Other related posts: