RE: how to stop a killed session bothering me ?
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 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 [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 this - I usually just suffer through the > > rollback. > > > > Jim > > > > __ > > Jim Hawkins > > Oracle Database Administrator > > Data Management Center of Expertise > > > > Pharmacia Corporation > > 800 North Lindbergh Blvd. > > St. Louis, Missouri 63167 > > (314) 694-4417 > > > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Tuesday, August 07, 2001 8:21 AM > > To: Multiple recipients of list ORACLE-L > > > > > > 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 possible recover > > problem later. You see that it is a little risky. > > With > > a shutdown immediate, you might wait a lot. Even > > that > > you could afford it because of the dangerous of > the > > abort option. The other is to issue through > svrmgrl > > or > > sqlplus depending on the release an > > > > oradebug wakeup on > > the release> > > > > However there is a little chance that with this > you > > could hurry the PMON for the rollback of the > > transaction. > > > > You can see how much work the PMON or SMON have to > > do > > through v$transaction: > > > > select b.sid,a.used_ublk from v$transaction > > a,v$session b > > where addr=taddr and b.status='KILLED'; > > > > > > Regards. > > > > > > --- Andrey Bronfin <[EMAIL PROTECTED]> > > wrote: > > > Dear all ! > > > I have killed a session while it was populating > a > > > big table. > > > Now the session is marked KILLED in v$session. > > > It's serial# is keeping being incremented , so i > > > assume that a rollback (of > > > rows inserted into that big table by that > session) > > > is going on there in the > > > background. > > > This rollback runs for several hours already > > > preventing me from DMLing that > > > big table. > > > Is there a way to stop that rollback / drop / > > > truncate that table ? > > > Thanks a lot in advance . > > > Andrey. > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Andrey Bronfin > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: > > > (858) 538-5051 > > > San Diego, California-- Public Internet > > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send > an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB > > > ORACLE-L > > > (or the name of mailing list you want to be > > removed > > > from). You may > > > also send the HELP command for other information > > > (like subscribing). > > > > > > = > > Eng. Christian Trassens > > Senior DBA > > Systems Engineer > > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > > Phone : 541149816062 > > > > __ > > Do You Yahoo!? > > Make international calls for as low as $.04/minute > > with Yahoo! Messenger > > http://phonecard.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Christian Trassens > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: HAWKINS, JAMES W [IT/1000] > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-
RE: how to stop a killed session bothering me ?
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 shutdown abort lightly, I perfer not to do it and I avoid it, but if I need to do it, I do it without hesitation and without concern I am in danger. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 9:21 AM To: Multiple recipients of list ORACLE-L 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 possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear all ! > I have killed a session while it was populating a > big table. > Now the session is marked KILLED in v$session. > It's serial# is keeping being incremented , so i > assume that a rollback (of > rows inserted into that big table by that session) > is going on there in the > background. > This rollback runs for several hours already > preventing me from DMLing that > big table. > Is there a way to stop that rollback / drop / > truncate that table ? > Thanks a lot in advance . > Andrey. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to stop a killed session bothering me ?
MaybeHowever in my experience a shutdown abort and startup was most of the times quickier than shutdown immediate and wait for the unfinished rollback. Remember that one thing is recover because of the abort and another thing is to rollback managed by the parameter cleanup_rollback_entries and in the wakeup frecuency of PMON. Even though pay now or pay later sometimes is true. :) --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > 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 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.orafaq.com > >-- > >Author: Page, Bruce > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > >San Diego, California-- Public Internet > access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an > E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > >the message BODY, include a line containing: UNSUB > ORACLE-L > >(or the name of mailing list you want to be removed > from). You may > >also send the HELP command for other information > (like subscribing). > > > _ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to stop a killed session bothering me ?
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 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.orafaq.com >-- >Author: Page, Bruce > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to stop a killed session bothering me ?
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 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 > Data Management Center of Expertise > > Pharmacia Corporation > 800 North Lindbergh Blvd. > St. Louis, Missouri 63167 > (314) 694-4417 > > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, August 07, 2001 8:21 AM > To: Multiple recipients of list ORACLE-L > > > 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 possible recover > problem later. You see that it is a little risky. With > a shutdown immediate, you might wait a lot. Even that > you could afford it because of the dangerous of the > abort option. The other is to issue through svrmgrl or > sqlplus depending on the release an > > oradebug wakeup the release> > > However there is a little chance that with this you > could hurry the PMON for the rollback of the > transaction. > > You can see how much work the PMON or SMON have to do > through v$transaction: > > select b.sid,a.used_ublk from v$transaction > a,v$session b > where addr=taddr and b.status='KILLED'; > > > Regards. > > > --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > > Dear all ! > > I have killed a session while it was populating a > > big table. > > Now the session is marked KILLED in v$session. > > It's serial# is keeping being incremented , so i > > assume that a rollback (of > > rows inserted into that big table by that session) > > is going on there in the > > background. > > This rollback runs for several hours already > > preventing me from DMLing that > > big table. > > Is there a way to stop that rollback / drop / > > truncate that table ? > > Thanks a lot in advance . > > Andrey. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Andrey Bronfin > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > = > Eng. Christian Trassens > Senior DBA > Systems Engineer > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : 541149816062 > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Christian Trassens > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: HAWKINS, JAMES W [IT/1000] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califor
RE: how to stop a killed session bothering me ?
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 [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 this - I usually just suffer through the > rollback. > > Jim > > __ > Jim Hawkins > Oracle Database Administrator > Data Management Center of Expertise > > Pharmacia Corporation > 800 North Lindbergh Blvd. > St. Louis, Missouri 63167 > (314) 694-4417 > > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, August 07, 2001 8:21 AM > To: Multiple recipients of list ORACLE-L > > > 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 possible recover > problem later. You see that it is a little risky. > With > a shutdown immediate, you might wait a lot. Even > that > you could afford it because of the dangerous of the > abort option. The other is to issue through svrmgrl > or > sqlplus depending on the release an > > oradebug wakeup the release> > > However there is a little chance that with this you > could hurry the PMON for the rollback of the > transaction. > > You can see how much work the PMON or SMON have to > do > through v$transaction: > > select b.sid,a.used_ublk from v$transaction > a,v$session b > where addr=taddr and b.status='KILLED'; > > > Regards. > > > --- Andrey Bronfin <[EMAIL PROTECTED]> > wrote: > > Dear all ! > > I have killed a session while it was populating a > > big table. > > Now the session is marked KILLED in v$session. > > It's serial# is keeping being incremented , so i > > assume that a rollback (of > > rows inserted into that big table by that session) > > is going on there in the > > background. > > This rollback runs for several hours already > > preventing me from DMLing that > > big table. > > Is there a way to stop that rollback / drop / > > truncate that table ? > > Thanks a lot in advance . > > Andrey. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Andrey Bronfin > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > = > Eng. Christian Trassens > Senior DBA > Systems Engineer > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : 541149816062 > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute > with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Christian Trassens > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: HAWKINS, JAMES W [IT/1000] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). _
RE: how to stop a killed session bothering me ?
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.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to stop a killed session bothering me ?
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 this - I usually just suffer through the > rollback. > > Jim > > __ > Jim Hawkins > Oracle Database Administrator > Data Management Center of Expertise > > Pharmacia Corporation > 800 North Lindbergh Blvd. > St. Louis, Missouri 63167 > (314) 694-4417 > > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, August 07, 2001 8:21 AM > To: Multiple recipients of list ORACLE-L > > > 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 possible recover > problem later. You see that it is a little risky. > With > a shutdown immediate, you might wait a lot. Even > that > you could afford it because of the dangerous of the > abort option. The other is to issue through svrmgrl > or > sqlplus depending on the release an > > oradebug wakeup the release> > > However there is a little chance that with this you > could hurry the PMON for the rollback of the > transaction. > > You can see how much work the PMON or SMON have to > do > through v$transaction: > > select b.sid,a.used_ublk from v$transaction > a,v$session b > where addr=taddr and b.status='KILLED'; > > > Regards. > > > --- Andrey Bronfin <[EMAIL PROTECTED]> > wrote: > > Dear all ! > > I have killed a session while it was populating a > > big table. > > Now the session is marked KILLED in v$session. > > It's serial# is keeping being incremented , so i > > assume that a rollback (of > > rows inserted into that big table by that session) > > is going on there in the > > background. > > This rollback runs for several hours already > > preventing me from DMLing that > > big table. > > Is there a way to stop that rollback / drop / > > truncate that table ? > > Thanks a lot in advance . > > Andrey. > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Andrey Bronfin > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > = > Eng. Christian Trassens > Senior DBA > Systems Engineer > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Phone : 541149816062 > > __ > Do You Yahoo!? > Make international calls for as low as $.04/minute > with Yahoo! Messenger > http://phonecard.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Christian Trassens > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: HAWKINS, JAMES W [IT/1000] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls
RE: how to stop a killed session bothering me ?
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 Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 07, 2001 8:21 AM To: Multiple recipients of list ORACLE-L 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 possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear all ! > I have killed a session while it was populating a > big table. > Now the session is marked KILLED in v$session. > It's serial# is keeping being incremented , so i > assume that a rollback (of > rows inserted into that big table by that session) > is going on there in the > background. > This rollback runs for several hours already > preventing me from DMLing that > big table. > Is there a way to stop that rollback / drop / > truncate that table ? > Thanks a lot in advance . > Andrey. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to stop a killed session bothering me ?
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 possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear all ! > I have killed a session while it was populating a > big table. > Now the session is marked KILLED in v$session. > It's serial# is keeping being incremented , so i > assume that a rollback (of > rows inserted into that big table by that session) > is going on there in the > background. > This rollback runs for several hours already > preventing me from DMLing that > big table. > Is there a way to stop that rollback / drop / > truncate that table ? > Thanks a lot in advance . > Andrey. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to stop a killed session bothering me ?
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 Bronfin <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: how to stop a killed session bothering me ? >Date: Tue, 07 Aug 2001 01:47:00 -0800 > >Dear all ! >I have killed a session while it was populating a big table. >Now the session is marked KILLED in v$session. >It's serial# is keeping being incremented , so i assume that a rollback (of >rows inserted into that big table by that session) is going on there in the >background. >This rollback runs for several hours already preventing me from DMLing that >big table. >Is there a way to stop that rollback / drop / truncate that table ? >Thanks a lot in advance . >Andrey. >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).