Re: Rollback segments

In article <9s4u5u$dri$1_at_news.netmar.com>, peter.mckenzie_at_health.wa.gov.au says...
>
>Could someone please tell me what the best way is to find out (using sql) who
>is tying up rollback segments and how much rollback space they are using.
>Oracle 7.3.4.3.0
>Thanks.
>
>

used_ublk is the number of blocks they are using in the rbs

  1 select b.segment_name, a.username, a.sid, a.serial#, c.used_ublk   2 from v$session a, dba_rollback_segs b, v$transaction c   3 where b.segment_id = c.xidusn
  4* and a.taddr = c.addr
ops$ora734_at_ORA734.WORLD> /

SEGMENT_NAME                   USERNAME                              SID   

------------------------------ ------------------------------ ----------
---------- ----------
RBS_04                         SCOTT                                   8        
78          1
RBS_01                         SCOTT                                   7        
11          1

>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
>made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp