Re: Q: Rollback segment

From: Colin Polykett <polyketc_at_spam.bibip1.wgw.bt.co.uk>
Date: 1997/04/28
Message-ID: <3364780B.7966@spam.bibip1.wgw.bt.co.uk>#1/1

EAL wrote:
>
> Hi netters. Is there a way to determine which process is using which
> rollback segment? Thanks.

Yes.

select	sid,
	username,
	segment_id
from 	v$session,
	v$transaction,
	dba_rollback_segs
where 	taddr=addr
and 	xidusn=segment_id;

This will list SID, username and the segment_id for each current transaction. Join to v$process as required.

---

These views are mine, all mine

Colin Polykett polyketc_at_bibip1.wgw.bt.co.uk Certified Oracle DBA Received on Mon Apr 28 1997 - 00:00:00 CDT