RE: database file sizes....more of smaller size or less of larger

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-----
Sent: Wednesday, February 12, 2003 12:04 PM To: Multiple recipients of list ORACLE-L 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

• Rick_Cale_at_teamhealth.com 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
  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).