Oracle-L: RE: rollback_segment who is using?

From: Kevin Lange <kgel_at_ppoone.com>
Date: Fri, 04 Oct 2002 14:13:51 -0800
Message-ID: <F001.004E16AF.20021004141351@fatcity.com>

If you have TOAD with the DBA module , it can tell you which is being used by whom.

If not, here is the sql statement that generates the list :

SELECT   r.NAME, -- rbs name
         s.sid, s.serial#, s.username, s.machine, t.status,
         t.cr_get, -- consistent gets
         t.phy_io, -- physical IO
         t.used_ublk, -- Undo blocks used
         t.noundo, --   Is a noundo transaction
         SUBSTR (s.program, 1, 78) "COMMAND", s.username "DB User",
t.start_time,
         s.sql_address
               "Address", s.sql_hash_value "Sql Hash"

FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r WHERE t.addr = s.taddr AND t.xidusn = r.usn ORDER BY t.start_time

-----Original Message-----
Sent: Friday, October 04, 2002 4:38 PM
To: Multiple recipients of list ORACLE-L

Dear List,

Some developers had written the code to use the particular rollback segments. how to find out which session is using which rollback segment?

Thanks in advance
Sarath

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com
--

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

Author: sarath kumar
INET: sarath_kumar0_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------