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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l