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
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
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
tried
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:
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 wait
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
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 me ?
Date: Tue, 07 Aug 2001 07:16:08 -0800
Pay Oracle now
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
If you did a shutdown abort, wouldn't you
still have to wait for the
rollback to happen during instance recovery
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
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 to
10 matches
Mail list logo