You can try this script also..courtesy this list
set linesize 120
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, substr(c.segment_name,1,10) "RBS"
, e.process "PROCESS"
, substr(d.used_urec,1,8) "# of Records"
from v$loc
Wow thank you:) I knew it had to exist.
KK
-Original Message-
Tom
Sent: Friday, July 06, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
I believe that I got this off of this list a while back...
clear columns
column rbs format A7 heading 'RBS'
column ora_usr format a10
colu
I believe that I got this off of this list a while back...
clear columns
column rbs format A7 heading 'RBS'
column ora_usr format a10
column program format a39
column sid format
select r.name rbs,
s.sid SID,
substr(osuser,1,10) os_user,
nvl(s.username, ' -- ') ora_u
