Re: Here's one for the Gurus: ROLLBACK SEGMENT/USERS

From: saar <sxmaxoz_at_us.oracle.com>
Date: Fri, 19 Jun 1998 09:58:56 -0700
Message-ID: <358A98CF.598A382C@us.oracle.com>

> But how do I see which user is using which rollback segment if they do
> not use this?
>

A transaction is using a rollback segment so that info is in v$transaction:select ses_addr,xidusn from v$transaction;

join this with SADDR from v$session to get more info on the session, or SEGMENT_NAME from dba_rollback_segs
to get more info on the rollback segement name.

Saar.

--

 __  _    _  __    _ _   _   _ ___  ______________________________
((  /\\  /\\ ||)  |\V/| /\\ /\\ >/  Principal Performance Engineer

_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Digital SBU

////////////////// Drop x's in email (spam) //////////////////////

Received on Fri Jun 19 1998 - 11:58:56 CDT