quiesce模式下只有DBA(sys或system)的事务可被执行,正在执行的session不受影响。
语法:
alter system quiesce restricted;
alter system unquiesce;
当所有的非DBA的session变为inactive时,该语句结束,所以,有可能等待很长的时间。
查询谁在阻塞quiesce动作:
select bl.sid, user, osuser, type, program
from v$blocking_quiesce bl, v$session se
where bl.sid = se.sid;
示例如下:
SQL> alter system quiesce restricted;
System altered.
SQL> select active_state from v$instance;
ACTIVE_ST
---------
QUIESCED
SQL> alter system unquiesce;
System altered.
SQL> select active_state from v$instance;
ACTIVE_ST
---------
NORMAL
语法:
alter system quiesce restricted;
alter system unquiesce;
当所有的非DBA的session变为inactive时,该语句结束,所以,有可能等待很长的时间。
查询谁在阻塞quiesce动作:
select bl.sid, user, osuser, type, program
from v$blocking_quiesce bl, v$session se
where bl.sid = se.sid;
示例如下:
SQL> alter system quiesce restricted;
System altered.
SQL> select active_state from v$instance;
ACTIVE_ST
---------
QUIESCED
SQL> alter system unquiesce;
System altered.
SQL> select active_state from v$instance;
ACTIVE_ST
---------
NORMAL
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11946422/viewspace-667925/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11946422/viewspace-667925/