The ACTIVE_STATE value of V$INSTANCE will be QUIESCED.
All of views in normal mode are available in QUIESCED mode. DBA transactions are unaffected. User transactions are not processed.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998