Yes upon startup. When you kill and the session
doesn't leave their locks and changes its serial# as a
few of its symptons, PMON take charge.
--- "A. Bardeen" <[EMAIL PROTECTED]> wrote:
> Jim,
>
> No, since 7.3 SMON does the rollback in the
> background
> upon startup. If a user session attempts
Doing a shutdown abort is hardly dangerous.
Granted, it is not as clean as shutdown normal or shutdown abort, but it is
not dangerous.
All it does is severe the connections. When the instance comes up, it goes
through and starts rolling back looking through rbs and redo logs.
I look at shutdow
ROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >Subject: RE: how to stop a killed session bothering
> me ?
> >Date: Tue, 07 Aug 2001 07:16:08 -0800
> >
> >Pay Oracle now or pay Oracle later
&g
gee, I thought it was "pay Oracle now AND pay Oracle later" :)
>From: "Page, Bruce" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: how to stop a killed session bothering
Right, as we like to say 'you can pay smon now or you can pay him later' but
he will get his due.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 10:50 AM
> If you did a "shutdown abort", wouldn't you still have to w
Jim,
No, since 7.3 SMON does the rollback in the background
upon startup. If a user session attempts to access a
row that is part of an uncommitted transaction that
needs rolling back then that user session will take
over the rollback of that transaction.
HTH,
-- Anita
--- "HAWKINS, JAMES W
Pay Oracle now or pay Oracle later
> If you did a "shutdown abort", wouldn't you still have to wait for the
> rollback to happen during instance recovery on the startup?
> I've never
> tried this - I usually just suffer through the rollback.
--
Please see the official ORACLE-L FAQ: http://www.
Yes, but it is painless in comparison with the one
done through shutdown immediate.
--- "HAWKINS, JAMES W [IT/1000]"
<[EMAIL PROTECTED]> wrote:
> If you did a "shutdown abort", wouldn't you still
> have to wait for the
> rollback to happen during instance recovery on the
> startup? I've never
>
If you did a "shutdown abort", wouldn't you still have to wait for the
rollback to happen during instance recovery on the startup? I've never
tried this - I usually just suffer through the rollback.
Jim
__
Jim Hawkins
Oracle Database Administrator
You should wait for PMON ending its job of rollback
the transaction of that killed session. Since one of
the releases of 8i that duty is a new one for the
SMON.
You have few options. If you are in a hurry, you could
do shutdown abort. First issue an alter system
checkpoint; just in case a maybe
you could delete the entire database, then recover it and do a cancel and
resetlogs before the time when you started the table populate ... short of
that, no there is no way to stop the rollback, nor would you want to as it
would leave your database in an inconsistent state
>From: Andrey Bron
11 matches
Mail list logo