Re: Datafile setting

From: Anup Jalan <anup.jalan_at_rave-tech.com>
Date: 22 Jan 2003 04:13:50 -0800
Message-ID: <532afd4.0301220413.2c23bfa@posting.google.com>

Generally, autoextend datafile should be avoided. There is always the danger of irresponsible transactions eating up too much space. Also, frequent autoextend slows down the system.

Better to estimate the max size you will need and allocate it upfront.

However, when I feel too lazy to follow my own advice :), I set the autoextend value to around 10% of the initial size, and the max value to double the initial size.

Anup Jalan
Rave Technologies
www.rave-tech.com

"Pacific" <henryl_at_asper.com.hk> wrote in message news:<b0igm5$1sm$1_at_hfc.pacific.net.hk>...
> Hi,
>
> We are using Oracle 9.0.1.3 database and under linux RH 7.1 platform. We
> have about 20 users. We are now trying to estimate the datafile autoextend
> sizing. i.e. block size. Does anyone has suggestion on the datafile
> autoextend sizing ?? How can i get the sizing guide about this issue ??
>
> Henry
Received on Wed Jan 22 2003 - 06:13:50 CST