Re: rollback segment

From: <markp7832_at_my-deja.com>
Date: Tue, 22 Feb 2000 14:58:20 GMT
Message-ID: <88u86a$ss$1@nnrp1.deja.com>

In article <88sqof$1qd$1_at_nnrp1.deja.com>, rrajeshr_at_my-deja.com wrote:
> an anyone advise regarding sizing of rollback segments
> for the database size of 5GB and contains CLOB, LONG and Varchar
> data,The transaction/day will be 200,000 records in this 10% will
> be clob data 20% LONG and remaining will be varchar, the size of
> CLOB and LONG will be upto 300MB.
> All the data will be purged everyday after taking a tape backup.
>

First off it is my understanding that LOB datatypes do not use regular rbs segments to record change information but use their regular storage based on a parameter.

This means you only have to worry about the non-lob columns. The question is how big is your average update transaction? Your rbs extent size should probably be a minimum 4X you expected average transaction size and you want to allocate 20 extents per segment as Oracle recommends.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 08:58:20 CST