"Database Time Spent Waiting (%)" at 100 for Event Class "Other" when Database is not Under Load
Last updated on SEPTEMBER 12, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
- 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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms