SELECT s.sid, s.username, s.program,
t.used_ublk, t.used_urec,t.used_ublk,c.segment_name,c.tablespace_name
FROM v$session s, v$transaction t , dba_rollback_segs c
WHERE s.taddr = t.addr
and t.xidusn = c.segment_id
;

-----Original Message-----
From: Zhang Brenda
[mailto:oracledba-ezmlmshield-x66178440.[Email address protected]
Sent: Wednesday, March 30, 2005 2:18 PM
To: LazyDBA Discussion
Subject: FW:



> ______________________________________________
> From: Zhang, Brenda
> Sent: Wednesday, March 30, 2005 1:18 PM
> To: LazyDBA Discussion
> Subject:
>
> How do I know particular session is using which rollback segment?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page