| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
DBA Elcom, Inc.
voice - 781-501-4143 (direct #)
fax - 781-278-8341 (secure)
email - psherman_at_elcom.com
-----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 <gurelei_at_yahoo.com>
Sent by: root_at_fatcity.com
07/15/2002 02:39 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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
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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Tue Jul 16 2002 - 11:04:04 CDT
 |
 |