RE: rollback tables

From: Jon Walthour <jonw_at_fuse.net>
Date: Mon, 13 Aug 2001 07:58:22 -0700
Message-ID: <F001.00368A4F.20010813065941@fatcity.com>

Srinivas:

This query will tell you if your current session is using a rollback segment:

SELECT s.sid

, rn.name

  FROM sys.v_$session s
     , sys.v_$transaction t
     , sys.v_$rollname rn
     , (SELECT distinct sid
          FROM          sys.v_$mystat) m

WHERE t.addr = s.taddr
AND rn.usn = t.xidusn
AND s.sid = m.sid;

HTH, Jon Walthour

-----Original Message-----
Shrinivas (MED, Keane)
Sent: Monday, August 13, 2001 4:36 AM
To: Multiple recipients of list ORACLE-L

HI dba's

can anybody tell me

from which tables can i find whether my statement is generating rollback.

post queries if you have..

thnx
srinivas
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Tatireddy, Shrinivas (MED, Keane) INET: Shrinivas.Tatireddy_at_med.ge.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: Jon Walthour
INET: jonw_at_fuse.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------