Re: rollback segment question

You shouldn't rely on v$parameter with this one. It will list the *private* rollback segments only, not the *public* (public rollback segments are for Oracle Parallel Server configs). Instead you need to use
dba_rollback_segs
or v$rollstat and v$rollname.
V$rollstat has an xact column which will show you the number of active transactions.
If you don't explicitly use set transaction use rollback segment however you will get a random rollback segment as these are allocated in round-robin, circular fashion.

Hth,

[Quoted] Sybrand Bakker, Oracle DBA

<terry_stjean_at_my-deja.com> wrote in message news:8ms6u3$2a9$1_at_nnrp1.deja.com...
> I have a procedure which doesn't specify a rollback segment.
> Also, I checked the view v$parameter and there is no rollback listed
> there. So my question is, when I run this procedure, what rollback
> segment does it used?
>
> Terry
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Wed Aug 09 2000 - 00:00:00 CEST