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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
