datafile greater than 2GB

[gopi]

Oracle 9.2 64-bit on Solaris 8

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?

additional info
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.

Than You!

[Mr.Hanky]

Hey Gopi;
Do you have large files enabled? If not then you may not be able to go above 2gig.
I don’t see why you can’t just add another datafile.

MH

[gopi]

Originally posted by Mr.Hanky

I don’t see why you can’t just add another datafile.

Adding another file has always been automatic for me. With 9i and Solaris 8 I was aware of the possibility of going > 2GB. So, I'm just learning what that is all about, pros, cons...etc...

I'll ask my sys admin about large files enabled.

thanks!

[Mr.Hanky]

Well I know some have made the argument that having datafiles no larger than 2 gigs is beneficial for a few reasons. Overall they are easier to manage/move/recover, so I say go with that.

MH

[kris109]

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.

[julian]

Originally posted by kris109

I find smaller datafiles as opposed to 4Gig file are easier for backup (you can use parallel OS copy using multiple CPU's).

Well, how about using RMAN!

[Mr.Hanky]

RMAN?

Never heard of it.

MH

[grjohnson]

On your configuration (Oracle 9i and Solaris 8) I'd go for 4GB datafiles. I use a max of 2GB for any DB 8.0.x and lower.

[agasimani]

Your setup supports 4GB datafiles.