> -----Original Message-----
> From: Charlie Mengler [mailto:[EMAIL PROTECTED]]
>
> If I'm interested in a specific RBS, how do I determine which user(s)
> are making use of this segement?
>
> How do I determine which RBS a particular user is using?
You could try this script (I have used it on Oracle Server 8.1.x)
From
Oracle FAQ: Script and Code Exchange
Database Performance Tuning Scripts
http://www.orafaq.com/faqscrpt.htm#DBATUNE
Display database sessions using rollback segments
http://www.orafaq.com/scripts/sql/rbs_act.txt
rem -----------------------------------------------------------------------
rem Filename: rbs_act.sql
rem Purpose: Display database sessions using rollback segments
rem Author: Anonymous
rem -----------------------------------------------------------------------
col RBS format a5 trunc
col SID format 9990
col USER format a10 trunc
col COMMAND format a78 trunc
col status format a6 trunc
SELECT r.name "RBS", s.sid, s.serial#, s.username "USER", t.status,
t.cr_get, t.phy_io, t.used_ublk, t.noundo,
substr(s.program, 1, 78) "COMMAND"
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.cr_get, t.phy_io
/
