RE: Query Database while shutdown in progress

The simplest method on unix is to tail -f the alert log.  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sinardy Xing Sent: Tuesday, June 26, 2007 9:58 PM
To: oracle-l
Subject: 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 






------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

==============================================================================


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