Restricted database access

1.

startup restrict;

SYS@sales 2013-08-25 04:37:12> alter system disable restricted session;

##open for you ,but not for general users

2.

SYS@sales 2013-08-25 04:36:49> alter system enable restricted session;

System altered.

SYS@sales 2013-08-25 04:37:12> alter system disable restricted session;

System altered.

##restricted 限制新用户访问,当前用户不受影响。

3.

SYS@sales 2013-08-25 04:39:01> alter system quiesce restricted;

System altered.

SYS@sales 2013-08-25 04:39:58> alter system unquiesce;

System altered.

##所有general user的操作都会hang在排队。等unquisce后，继续执行。

4.

SQL> ALTER SYSTEM SUSPEND;
System altered.
SQL> ALTER SYSTEM RESUME;
System altered.
SQL>

##If you want to suspend all I/O operations during some special administrative job,