resmgr:become active
这个等待事件的解释
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.
从描述上看这个等待事件的原因和resource manager有关,由于不是很熟悉这东西,自然请google帮忙,在搜索
select * from V$RSRC_PLAN ;
至此就明白了问题的原因,解决的方法很简单
alter system SET resource_manager_plan = '';
INTERNAL_QUIESCE:
INTERNAL_QUIESCE - freezes all sessions out (by setting max number of sessions to 0) except for SYS_GROUP