A little more detail:
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rocky Welch
Sent: Friday, February 02, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: 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!
