How about "consistent file sizes?" For raw the VLDB whitepaper recommends something like 128MB, 1GB, and 8GB but isn't it also a good practice for cooked? It depends...
-----Original Message-----
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: database file sizes....more of smaller size or less of
larger size?
Importance: High
the ever popular answer "it depends"
how large are the tables you are storing in these datafiles? Is this a
data warehouse where you will be storing massive amounts of data? (1000
2GB datafiles to store one table's worth of data is somewhat obscene)
Is it a large database? Heavily used? OLTP?
I'm not making fun, it's just that a blanket statement "what are the
pros and cons" just doesn't make sense
--- [EMAIL PROTECTED] wrote:
> Hi DBAs,
>
> Oracle 8.1.7 WinNT
>
> I would like pros/cons on datafile sizes. It is better to have more
> of less
> size or less with larger sizes and why?
>
> Thanks
> Rick
