The session is waiting for a resource manager active session slot. This event occurs when the resource manager is enabled and the number of active sessions in the session's current consumer group exceeds the current resource plan's active session limit for the consumer group. To reduce the occurrence of this wait event, increase the active session limit for the session's current consumer group.
Wait Time: The time the session waited to be allocated an active session slot
|location||location of the wait|
"The Database Resource Manager blocks all actions that were initiated by a user other than SYS or SYSTEM while the system is quiesced.
Oracle instructs the Database Resource Manager in all instances to prevent all inactive sessions (other than SYS and SYSTEM) from becoming active. No user other than SYS and SYSTEM can start a new transaction, a new query, a new fetch, or a new PL/SQL operation.
During the quiesced state, you cannot change the Resource Manager plan in any instance. "
NORMAL: Normal unquiesced state.
QUIESCING: Being quiesced, but some non-DBA sessions are still active.
QUIESCED: Quiesced; no non-DBA sessions are active or allowed.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23132642/viewspace-718804/，如需转载，请注明出处，否则将追究法律责任。