Oracle-L: RE: user(s) & RBS

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 30 Jul 2002 15:18:37 -0800
Message-ID: <F001.004A6B93.20020730151837@fatcity.com>

> -----Original Message-----
> From: Charlie Mengler [mailto:charliem_at_mwh.com]
>
> 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
/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).

Received on Tue Jul 30 2002 - 18:18:37 CDT