Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Rollback segment

Re: Q: Rollback segment

From: Brett Neumeier <random_at_interaccess.com>
Date: 1997/04/24
Message-ID: <335FDFF0.6669@interaccess.com>#1/1

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

from v$rollname a, v$session b, v$transaction c where a.usn = c.xidusn

        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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US