Re: Which RBS is my Update using ?

From: Andy <enzoweb_at_hotmail.com>
Date: 12 Sep 2002 21:02:11 -0700
Message-ID: <8d4033cd.0209122002.31cba580@posting.google.com>

Try this:

COLUMN "RBSeg" FORMAT a7
COLUMN "Sid,Serial/Pid" FORMAT a14
COLUMN "Username/Osuser" format a18
COLUMN "OsPid" FORMAT a5
COLUMN "UsrPid/OSProg" FORMAT A33
COLUMN "sql_text" for a50 wrap

SELECT r.name "RBSeg",

s.sid ||','|| s.serial# ||'/'|| p.pid "Sid,Serial/Pid",
s.username ||' '|| s.osuser "Username/Osuser",
p.spid "OSPid",
s.process ||','|| SUBSTR(s.program,1,27) "UsrPid/Osprog",

sq.sql_text sql_text
FROM

v$session s,
v$process p,
v$transaction t,
v$sqlarea sq,
v$rollname r

WHERE p.addr = s.paddr
and t.addr = s.taddr
and r.usn = t.xidusn
and sq.address(+) = s.sql_address
and sq.hash_value(+) = s.sql_hash_value;

"R Chin" <rchin_at_panix.com> wrote in message news:<alr1gu$nlo$2_at_reader1.panix.com>...
> How does one find out what RBS an DML is using ?
>
> Thanks
> Robert
Received on Thu Sep 12 2002 - 23:02:11 CDT