Re: Cooked Oracle data files - Optimal size?

In article <4fo71o$9at_at_news2.noc.netcom.net>, jill knowler <jknowler_at_dbintellect.com> wrote:

> I am creating a database with 'cooked' data files. That is, the files
> are not raw, but file system. I have created logical volumes, each
> spanning 2 or 3 disks. Is there an optimal file size for Oracle data
> files? I have asked advice from DBA's with more experience than me, and
> some say 500M and others say up to 2G. In the installation guide, it
> says that Oracle recommends that datafiles be no bigger than 500M. Can
> anyone offer advice on this? Does the fact that I have logical volumes
> influence this?

I use files anywhere from 500MB to about 1500MB; in my next revision of the database, we'll use 1GB (plus a few blocks) in order to make things more consistent, and easier to manage during create and backup. Logical volumes provide striping advantage, but little help or hurt on the file management front; no particular file size is 'best' from an Oracle perspective, outside of your ease of support.

David Scott                        ...how can I keep from singing?
                bumper snicker: My other guitar is a Martin (D16H)