I'm setting up a new application database for a customer who has hired a full-time dba. This system is on a Sun 4500 cluster with 2 D1000 disk arrays. This database will be no bigger than 50 gig with no more than 50 concurrent users. The full-time DBA inisists on 1 3gig datafile for the application (how he came up with that number I don't know) for reasons that there is less fragmentation. There is on large volume of 50gig which is striped and mirrored and a smaller 15gig concatnated and mirrored volume for the redo logs. Any thoughts? TIA, -Rocky   Gary Weber wrote: 3 Gb is not all that big. What platform is this on, can it handle larger files? Why is 3 Gb chosen as size below, as opposed to 2 or 4? What is your backup window, if any, and required recovery time?   Fwiw, I have one of the databases (DW) on HPUX 64bit with 4 and 6 Gb datafiles, residing happily on EMC Symmetrix...   Gary Weber   -----Original Message-----From: root@fatcity.com [mailto:root@fatcity.com]On Behalf Of Rocky WelchSent: Friday, February 02, 2001 4:20 PMTo: Multiple recipients of list ORACLE-LSubject: Who wants to build a tablespace... The question is...One BIG datafile (3 gig) or multiple smaller datafiles. You still have audience or phone a friend...your final answer? -Rocky Do You Yahoo!?- Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year! Do You Yahoo!? - Get personalized email addresses from Yahoo! Mail Personal Address - only $35 a year!