Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is quiesced state?

April 26, 2017Administrator allowed database DBA DBAs helpful perform State transactions

0

Posted

What is quiesced state?

1 Answer

0

Posted

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.