Re: System Modes QUIESCE / SUSPEND

From: Daniel <danielroy10junk_at_hotmail.com>
Date: 31 Jan 2006 05:57:22 -0800
Message-ID: <1138715842.883208.16160@g14g2000cwa.googlegroups.com>

>From the SQL manual:

"The SUSPEND clause lets you suspend all I/O (datafile, control file, and file header) as well as queries, in all instances, enabling you to make copies of the database without having to handle ongoing transactions.".

Specify UNQUIESCE to take the database out of quiesced state. Doing so permits transactions, queries, fetches, and PL/SQL procedures that were initiated by users other than SYS or SYSTEM to be undertaken once again. The UNQUIESCE statement does not have to originate in the same session that issued the QUIESCE RESTRICTED statement.

HTH Daniel Received on Tue Jan 31 2006 - 07:57:22 CST