Database Time Spent Waiting

From: mek s <sidi.bouzid.meknessy_at_gmail.com>
Date: Wed, 20 Jul 2011 11:56:31 +0200
Message-ID: <CAJX5RkTBmuo_XrE2izcDT=MOe8LGA+vzHtXjv8eoZSU-Fmx94A_at_mail.gmail.com>

*Hi Experts,

In my RAC 11gR2 environments, we daily have these warnings in DBA_OUTSTANDING_ALERTS
view.
I would like to anticipate any kind of future problems, Could you please let me know how to troubleshoot these warnings and know the root cause?

Thanks*

*REASON

---

METRIC_VALUE MESSAGE_TYPE TO_CHAR(CREATION_TIME,'DD-MON

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

HOST_ID

---

Metrics "Database Time Spent Waiting (%)" is at 67.9796 for event class "Other"
  67.9796018 Warning 20-JUL-2011 11:38:09 db02

Metrics "Database Time Spent Waiting (%)" is at 38.06099 for event class "Other"
  38.0609854 Warning 20-JUL-2011 11:35:46 db04
*

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 20 2011 - 04:56:31 CDT