Re: Query Database while shutdown in progress

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: Joel.Patterson@xxxxxxxxxxx
  • Date: Wed, 27 Jun 2007 13:45:58 -0700

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: