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
- Follow-Ups:
- RE: Query Database while shutdown in progress
- From: Robert Freeman
- RE: Query Database while shutdown in progress
- From: Joel.Patterson
- References:
- Re: Query Database while shutdown in progress
- From: Andrew Kerber
- RE: Query Database while shutdown in progress
- From: Joel.Patterson
Other related posts:
- » Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » Re: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
- » RE: Query Database while shutdown in progress
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.
- RE: Query Database while shutdown in progress
- From: Robert Freeman
- RE: Query Database while shutdown in progress
- From: Joel.Patterson
- Re: Query Database while shutdown in progress
- From: Andrew Kerber
- RE: Query Database while shutdown in progress
- From: Joel.Patterson