RE: Query Database while shutdown in progress
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>
- Date: Thu, 28 Jun 2007 09:28:45 -0400
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:
