Oracle 9i New Features - Static Database
Author: Lunar
In the release prior to Oracle 8i and 8i, if we want to perform some special tasks (such as Exp / Imp), or you want the database only to execute DBA transactions, queries, read, or PL / SQL statements, Turn off the database, then open the database in the restricted mode, which is strictly limited to systems that require 24 x 7 availability.
In Oracle 9i, Oracle provides a method of placing a database in a stationary state (ie, transactions, query, reading, or PL / SQL statements that allow DBA to be executed). DBA can place a database in a rest state by publishing a command "ALTER System Quiescence Restricted", which eliminates the shutdown time of the user's interrupt and the shutdown and restart the database.
note:
1. Here we say that DBA refers to the SYS or System user, and other users have SYSDBA system privileges or users who have the DBA role cannot use the function of the credit database.
2. Use this feature to make the database resource manager have been active.
Restore the system back to NORMAL, you can use the command:
Alter system unquesce;
