Oracle-L: Re: How do I check whether a rollback activity is going on

From: <Jared.Still_at_radisys.com>
Date: Mon, 15 Jul 2002 16:38:19 -0800
Message-ID: <F001.004989B9.20020715163819@fatcity.com>

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

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: gurelei_at_yahoo.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).

--

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
--------------------------------------------------------------------