Re: TRANSACTIONS_PER_ROLLBACK_SEGMENT (the real story)

From: john v <johnvue_at_gte.net>
Date: Tue, 04 Jan 2000 12:04:05 GMT
Message-ID: <89o37skkj9a3pqs4gu3ujkbeh0i93dqhpv@4ax.com>

On Tue, 4 Jan 2000 08:00:48 +0100, "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote:

>The real story may be higly misleading...
>
>If you have public rollback segments this parameter will determine (based on
>the number of processes in init<sid>.ora) how many rollback segments are
>brought online.
>This is, AFAIK, a one-time operation, rollback segments are not added
>dynamically.
>Hundred segments is outrageous. Oracle has the 'rule of four' which means
>one rollback segment for every four users, with a minumum of four rollback
>segments.
>

I have over 600+ users ... which mathematically works out to 150 rollback segments. I really didn't need that many so I cut it down to 100.

I've never been a big fan of the "divide by four" rule -- I'd rather go by # of simultaneous transactions at peak times. Received on Tue Jan 04 2000 - 06:04:05 CST