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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
