Re: [Q] Rollback segments; Small vs. large extents.

Doug Surplus <102621.3152_at_compuserve.com> wrote in article <32c2b3ef.176977810_at_news.sedona.net>...
<snip>
> You can also assign large transactions to specific rollback segments
> with 'SET TRANSACTION USE ROLLBACK SEGMENT rollback_segment_name' as
> the first statement in a transaction. Read only transactions can be
> set no using a rollback segment at all with 'SET TRANSACTION READ
> ONLY' .

<snip>
it is my understanding that r/o transactions depend *much more* on rbs to keep the data 'current' because all selects return the result they would have given at the point of the 'set transaction read only'. Oracle would use the rbs to 'serve' queries that need 'pre-committed' data. Anyone out there knows who's right???

        Gert

-- 
At Home: gem_at_wirehub.nl
At Work: gert.rijs_at_corp.ah.nl