Viewing the Quiesce State of an Instance - Oracle DBA

Q.  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?
- Published on 12 Aug 15

a. NORMAL
b. QUIESCING
c. QUIESCED
d. All mentioned above

ANSWER: All mentioned above

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 21 Aug 15
    -Occasionally you might want to put a database in a state that allows only DBA transactions, queries, fetches, or PL/SQL statements.

    -Such a state is referred to as a quiesced state, in the sense that no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements are running in the system.

    - 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- It is the normal unquiesced state.

    QUIESCING - It is being quiesced, but some non-DBA sessions are still active.

    QUIESCED - It is Quiesced; no non-DBA sessions are active or allowed.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲