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
column program format a39
column sid format 9999
select r.name rbs,
s.sid SID,
substr(osuser,1,10) os_user,
nvl(s.username, ' -- ') ora_usr,
s.program
from v$lock l, v$session s, v$rollname r
where l.sid = s.sid(+) and
trunc(l.id1(+)/65536) = r.usn and
l.type(+) = 'TX' and
l.lmode (+) = 6
order by r.name;
Tom Terrian
Oracle DBA
WPAFB - DAASC
[EMAIL PROTECTED]
937-656-3844
-----Original Message-----
Sent: Friday, July 06, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Does anyone have a script or know of a way to determine which user is
using
which rollback segment? I had a developer issue a "set transaction" before
she started a migration and I wanted to see if I could make sure that she
was using the proper rollback segment. Thanks a lot:)
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Terrian, Tom
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).