Re: Rollback Segments

Joe,

You can do it by using the following script: REM * show session in RBS

    SELECT SUBSTR(name,1,4) rbs_name,

           SUBSTR(username,1,12) u_name,
           sid, serial#, 
           z.rssize bytes,
           z.hwmsize max_size,
           z.aveactive avg_size
      FROM v$session, 
           v$rollname, 
           v$transaction, 
           v$rollstat z
     WHERE v$session.taddr = v$transaction.addr
       AND v$transaction.xidusn = v$rollname.usn
       AND v$rollname.usn = z.usn

Hope this helps,

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

In article <4jrsna$b5v_at_nntpa.cb.att.com>, jmjm_at_hogpf.ho.att.com (-J.MIKLEWICZ) writes:


>Is it possible to determine who is using rollback segments?

>

>I'm running Oracle Server 7.2.3 on Solaris 2.5

>

>Thanks,

>

>-- 

>

>---------------------------------------------------

>| Joe Miklewicz  908-949-3061  jmjm_at_hogpa.att.com |

>---------------------------------------------------