Database Time Spent Waiting

*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
*

Other related posts: