"Database Time Spent Waiting (%)" at 100 for Event Class "Other" when Database is not Under Load
(Doc ID 1526552.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document