Re: ROLLBACK segments' size: what criteria to size them ?

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 14 Nov 2000 17:28:05 GMT
Message-ID: <8ursmp$adj$1@nnrp1.deja.com>

In article <8urhin$vsu$1_at_nnrp1.deja.com>, monsri_at_my-deja.com wrote:
> Hi,
> I'd just like to know how you DBA's managed to choose
> your rollback segments size when you created your
> database(s)...
>
> Could you please gimme some advice about this issue ?
> You size your rbs depending on what in particular ? Is
> there a formula perhaps (kind of "# of users expected
> x size of tables + # of DML statements..." etc etc.) ??
>
> Thanks a lot!
>
> Regards,
> Seb
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Number of rollback segments depends on number of simultaneous transctions. Usually you should have 4 transactions per segment at average. Size depends on size of transzctions.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 14 2000 - 11:28:05 CST