Re: size of data files

I've read somewhere that having smaller files is better, b/c of UFS file locking (on UNIX), unless you're working with Raw or Quick I/O.

SO I try to stick with 500M for now (which isn't small, but I figure better then 2Gig)

On Tue, 16 Nov 1999 01:12:33 GMT, kal121_at_yahoo.com wrote:

>Hello,
>
>What are some general guidelines for sizing datafiles? I've heard
>datafiles should not exceed 1GB in size. What are the pros and cons for
>having large vs. small datafiles, relatively speaking? Performance
>considerations? For example, if Oracle is searching for single row,
>will it find it faster in a smaller datafile?
>
>thx
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email