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
Parameter | Description |
---|---|
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. "
感觉第2中可能性较为吻合。
于是查询实例状态:
-
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.
且alert日志中存在一条记录:
至于为什么数据库会被置为quiescing状态,原因未知,或许是认为的,也可能是orabf暴力破解密码造成的。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23132642/viewspace-718804/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23132642/viewspace-718804/