Re: Query Database while shutdown in progress

Your only option would be to open a seperate pre-connected session before issuing
the "SHUTDOWN IMMEDIATE" and then use that pre-connected sesssion to query V$TRANSACTION etc.

At 10:58 AM Wednesday, Sinardy Xing wrote:
>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
><<mailto:oracle.rdbms_at_gmail.com>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
>
>
>
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantscribbles.blogspot.com
and
http://hemantoracledba.blogspot.com

"First they ignore you, then they laugh at you, then they fight you, then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

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