RE: Rollback usage

From: Terrian, Tom <tterrian_at_daas.dla.mil>
Date: Fri, 06 Jul 2001 09:22:26 -0700
Message-ID: <F001.00343126.20010706092030@fatcity.com>

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
tterrian_at_daas.dla.mil
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
kevin_at_dulcian.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Kostyszyn
INET: kevin_at_dulcian.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Terrian, Tom
INET: tterrian_at_daas.dla.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------