Re: Database Sizing Question

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 18 Nov 1999 11:45:53 -0800
Message-ID: <811l2k$3n7$1@plo.sierra.com>

We use two basic strategies:

For our transaction-oriented systems (orders, accounting, purchasing, payroll, etc) we have many small rollback segments. This makes recovery time relative quick.

For our consumer registration (sort of warehouse) database, we have one 4GB rollback segment, roughly equal in size to the largest query we run (cartesion product of a 13M row table against itself)

Ken <kenchowhk_at_yahoo.com> wrote in message news:80mucb$ep12_at_imsp212.netvigator.com...
> Hi there,
>
> is there any guideline for defining the rollback segment
> sizing, temporary tablespace sizing and redo log sizing ?
>
> thanks
> Ken
>
>
Received on Thu Nov 18 1999 - 13:45:53 CST