RE: Query Database while shutdown in progress

Good page.  Just don't like being adamant if I am not very sure.

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: Jared Still [mailto:jkstill@xxxxxxxxx] 
Sent: Wednesday, June 27, 2007 4:46 PM
To: Patterson, Joel
Cc: andrew.kerber@xxxxxxxxx; robertgfreeman@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: Query Database while shutdown in progress

 

On 6/27/07, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx>
wrote:

        However, (Not from Oracle), I have heard oracle has gotten a lot
better with abort - as in not as dangerous or fearsome.   I just like
synchronizing all the file headers etc.... Does killing the session stop
the rollback?   If not, then monitoring the alert log for the offending
user is nice but doesn't save very many minutes.

See http://www.speakeasy.org/~jwilton/oracle/shutdown-abort-bad.html 

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: