Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Rollback segment
EAL wrote:
>
> Hi netters. Is there a way to determine which process is using which
> rollback segment? Thanks.
Sure. Try:
select a.name rbseg, b.sid, b.serial#, b.username,
decode (b.status, 'INACTIVE', '', 'ACTIVE', 'Active') status, decode (b.sql_hash_value, 0, '', 'SQL present') SQL_AREA
and c.addr = b.taddr
order by a.usn, b.sid
/
-bn
neumebm_at_hpd.abbott.com
Received on Thu Apr 24 1997 - 00:00:00 CDT