What is quiesced state?

What is quiesced state?

Rating:

A quiesced state is a state in which only Database Administrator (DBA) transactions are allowed. This state is helpful for the DBAs to perform tasks, which otherwise cannot be successfully completed unless all user transactions are stopped. The only other option to complete such tasks is to shutdown the system and restart it in restricted mode. To set the database in a quiesced state, the following statement is used:

ALTER SYSTEM QUIESCE RESTRICTED;

All the user transactions that were under processing, when the statement was issued, are allowed to execute until they become inactive. However, any non-DBA login that is made after issuing this statement is queued up and not allowed to proceed until the database is unquiesced.

Rating: