RE: How do I check whether a rollback activity is going on
Jared, I agree with you, except for when MTS is being used. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: Sherman, Paul R. 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 do I check whether a rollback activity is going on
Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: BALA,PRAKASH (Non-HP-USA,ex1) 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 do I check whether a rollback activity is going on
Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: BALA,PRAKASH (Non-HP-USA,ex1) 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: 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 do I check whether a rollback activity is going on
IRC, evn with MTS, a busy session should have the PID of the shared server associated with it in v$process, and only one session at a time can use the shared server. Killing it should effect only the session using the SS at that time, and MTS should spawn another. Nonetheless, I don't recommend doing it. :) Jared Sherman, Paul R. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I agree with you, except for when MTS is being used. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: Sherman, Paul R. 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: 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 do I check whether a rollback activity is going on
I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: BALA,PRAKASH (Non-HP-USA,ex1) 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: 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
RE: How do I check whether a rollback activity is going on
I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL and then if you wish to obsess on the subject: for x in $(kill -l) do print $x $(kill -l $x) done Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:41 AM To: Multiple recipients of list ORACLE-L I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: BALA,PRAKASH (Non-HP-USA,ex1) 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
RE: How do I check whether a rollback activity is going on
Kevin, Too much work! Just use: kill -9 -1 ;) you better read the man page first on this one. Jared kkennedy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL and then if you wish to obsess on the subject: for x in $(kill -l) do print $x $(kill -l $x) done Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:41 AM To: Multiple recipients of list ORACLE-L I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: BALA,PRAKASH (Non-HP-USA,ex1) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX
RE: How do I check whether a rollback activity is going on
try 'kill -l' where the -l is an ell as in -list. Jared mkb [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 11:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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: BALA,PRAKASH (Non-HP-USA,ex1) 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
RE: How do I check whether a rollback activity is going on
Yeah, ok, I forgot that in my youth the number one was typed by using the key immediately right of the K and the number zero was typed by using Shift and the key between I and P. I really meant kill -l using the letter to the right of the K, not that numeric symbol on the top row of the keyboard. Been a long time since I used kill -9 -1 -- I got out of the habit during my time on HPUX. And if anyone wants to try Jared's approach, be sure to log in as the oracle user on a critical production system and have your resume up to date 8-) Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Kevin, Too much work! Just use: kill -9 -1 ;) you better read the man page first on this one. Jared kkennedy [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 12:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I found this once but can't seem to find the full details at the moment. This will help though (Solaris8): kill -l # lists all kill signal names kill -l KILL # lists numeric equivalent for signal name KILL and then if you wish to obsess on the subject: for x in $(kill -l) do print $x $(kill -l $x) done Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Tuesday, July 16, 2002 11:41 AM To: Multiple recipients of list ORACLE-L I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538
RE: How do I check whether a rollback activity is going on
Thanks. That clarifies things. Time to look into this some more. mkb --- [EMAIL PROTECTED] wrote: try 'kill -l' where the -l is an ell as in -list. Jared mkb [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 11:41 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on I was wondering where a list of kill signals (kill -1, kill -9 etc) can be found. I've always used kill -9 but I'd rather try something less drastic first, even though I've never run into problems using kill -9 pid before. man pages don't seem to list the signals (Solaris 7). thanks mkb (hmmmcan you say mutating thread...) --- [EMAIL PROTECTED] wrote: Because 'kill' and 'kill -15' don't seem to work consistently. kill -9 says 'kill with extreme prejudice, take no prisoners!', whereas your garden variety kill allows a process to call for a priest, eat a last meal and smoke a cigarette, all of which take too much time. Jared BALA,PRAKASH (Non-HP-USA,ex1) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/16/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How do I check whether a rollback activity is going on Jared, I always kill the Oracle session first. So could you elaborate why you use 'kill -9'. TIA Prakash -Original Message- Sent: Monday, July 15, 2002 8:38 PM To: Multiple recipients of list ORACLE-L It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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 === message truncated === __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mkb 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
RE: How do I check whether a rollback activity is going on
You should see some activity in v$transaction. Regards, Waleed -Original Message- Sent: Monday, July 15, 2002 5:39 PM To: Multiple recipients of list ORACLE-L Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: Khedr, Waleed 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 do I check whether a rollback activity is going on
Gene, Run this repeatedly - used_ublk will reduce as it rolls back - after it is finished the session should dissappear. column sql_text word_wrapped select vs.sid, vs.serial#,vt.used_ublk, vt.start_time, vs.username, vs.osuser, substr(vsq.sql_text,1,75) sql_text from v$transaction vt, v$session vs, v$sqlarea vsq where vt.ses_addr = vs.saddr and vsq.address(+) = vs.sql_address / hth, Jack --- Gurelei [EMAIL PROTECTED] wrote: Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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). __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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 do I check whether a rollback activity is going on
It could be that pmon is rolling back the transaction. It could also be that pmon is never going to clean it up, which sometimes happens when killing an active transaction. I am a strong advocate of using 'orakill' on NT/Win2k and 'kill -9' on Unix to kill the process, rather than killing the session in Oracle. If your session has still not been cleaned up, you'll understand my position, as you will now have to bounce your database. Check to see if the session is holding a lock, if so, and an unreasonable amount of time has passed for pmon to do its cleanup, then you likely need to bounce the database. Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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 do I check whether a rollback activity is going on
Sorry, forgot to answer your question during all my ranting. select s.osuser ,s.username ,s.sid ,r.segment_name ,t.space ,t.recursive ,t.noundo ,t.used_ublk ,t.used_urec ,t.log_io ,t.phy_io ,substr(sa.sql_text,1,200) txt from v$session s, v$transaction t, dba_rollback_segs r, v$sqlarea sa where s.taddr=t.addr and t.xidusn=r.segment_id(+) and s.sql_address=sa.address(+); Jared Gurelei [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/15/2002 02:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How do I check whether a rollback activity is going on Hi. Here is my situation. I have killed an ORacle transaction. Oracle came back with session marked for kill and the status of the session is now Killed. I presume that the reason is that Oracle needs to roll back the changes made. Can I confirm whether this is indeed the case via some system tables? thakns gene __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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: 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).