Re: size of data files

That is 2 GB limit.
Small datafile doesn't imply to have better performance. It depends on how you organize your data and how you set up the access path/ indexes.

John Chiu

<kal121_at_yahoo.com> wrote in message news:80qb1v$vs1$1_at_nnrp1.deja.com...
> 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.
Received on Mon Nov 15 1999 - 20:20:54 CST