Re: Rollback segment used in exclusive mode : Why ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 19 Jun 1999 18:24:12 +0100
Message-ID: <929813279.11004.0.nnrp-04.9e984b29@news.demon.co.uk>

Actually this parameter tells Oracle how to work out the number of public rollback segments it should try to grab at start up time, it does not limit the number of transactions that can attach to a single rollback segment.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message
<929810132.19678.0.pluto.d4ee154e_at_news.demon.nl>...

>The second scenario is your rollback segment config. The parameter
>transactions per rollback segments usually is derived from the sessions (or
>processes) parameter, divided by the number of public rollback segments.
>Probably your rollback segments are private, so that shouldn't be the
>problem. I believe however you need to check on the current value of
>transactions_per_rollback_segments, because if that parameter equals 1 that
>is the explanation of your problem.
Received on Sat Jun 19 1999 - 12:24:12 CDT