Re: database file sizes....more of smaller size or less of

Rick,
 The answer is (YES, 42, IT DEPENTS). Not ot be smart but there in NO correct answer. The answer depents on may factors. 1. If the table is large, Why have it in may little extents. That could hurt performance if the data becomes chained. 2. If the table is small, why have it in a large extent wasting space. 3. If the table is static, I try the fill the tablespace to the limit and make the tablespace read-only. Back it up once and place it on the shelf.
4. If the table can be partitioned, set the tablespace and datafile accordingly.
5. etc etc etc.
There is no correct answer. Some of the dependancies are the disk arrangements and size that are available, the backup capabilities of the server, the capacity of the backup media, The mean time to repair in case of an error (human or machine).
 The answer is the one where you used your best judgement and were comfortable with.
I have datafiles from 4 M to 4 GIG.
Ron

>>> Rick_Cale_at_teamhealth.com 02/12/03 11:09AM >>>
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: 
  INET: Rick_Cale_at_teamhealth.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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).