I need more space for a tablespace. The tablespace is currently one 2GB datafile. My question is: should I increase the current datafile over the magic 2GB or add another datafile?
Unfortunately I have a dB setup using only three logical disks. Two logical disks are RAID-5 (4 physical disks each) and the third disk is mirrored and conatins only the archived logs. I have seperated indexes and data across both disks. We are a hybrid of OLTP and reporting applications.
We add about 2 datafiles of 2Gig each every week with a total of about 300 files.
I find smaller datafiles as opposed to 4Gig file are easier for backup (you can use parallel OS copy using multiple CPU's). You can use multiple channels (up to 15) in veritas netbackup media manager to finish daily backups and refreshes quicker.
Go for 2 Gig files.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g DBA