Oracle Database into a Quiesced State

-:Oracle Database into a Quiesced State:-

ALTER SYSTEM QUIESCE RESTRICTED;

select active_state from v$instance;

ACTIVE_ST

---------

QUIESCED

-:Restoring the System to Normal Operation:-

ALTER SYSTEM UNQUIESCE;

select active_state from v$instance;

ACTIVE_ST

---------

NORMAL

-:Viewing the Quiesce State of an Instance:-

You can query the ACTIVE_STATE column of the V$INSTANCE view to see the current state of an instance. The column values has one of these values:

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.

Source.

Oracle_Dba