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:22 -0800
Message-ID: <F001.004989E8.20020715163822@fatcity.com>

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 <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
--------------------------------------------------------------------
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 Mon Jul 15 2002 - 19:38:22 CDT