Monitor Shutdown immediate that required massive rollback

From: Sinardy Xing <Oracle.RDBMS_at_gmail.com>
Date: Wed, 27 Jun 2007 03:41:31 -0000
Message-ID: <1182915691.205426.56130@o11g2000prd.googlegroups.com>

Hi all,

When we shutdown Oracle instance with shutdown immediate mode. The Oracle will wait until all rollback completed.

The challenge is, how we can login to the instance to check the progress of rolling back, assume we are given sysdba privilege.

Our attempt:
Login / as sysdba unable to query v$transaction. as shutdown in progress not allow query.
Why Oracle allow to log in as sysdba while nothing can be done in the so call session.

Thanks for sharing your ideas. Received on Tue Jun 26 2007 - 22:41:31 CDT