Re: Query Database while shutdown in progress

Hi all,

I would like to rephrase my question, how do we monitor the progress of
shutting down immediate mode.


Thanks.



On 6/27/07, Sinardy Xing <oracle.rdbms@xxxxxxxxx> wrote:


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.

--
regards,
Santos

Other related posts: