"Database Time Spent Waiting (%)" at 100 for Event Class "Other" when Database is not Under Load

Last updated on SEPTEMBER 12, 2014

Applies to:

Symptoms

• The following message is received from Enterprise Manager even though there is no load against the database In EM the screen looks like this:
  
  
  
• In the AWR report for the time frame of the problem, it shows that the "DB Time" is very small compare to "Elapsed time"
  
  (Note, that in this example the timeframe is slightly different since the screenshots are actually from different databases and are for illustration purposes only)

Changes

 none

Cause