-
datafile greater than 2GB
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!
-
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
I remember when this place was cool.
-
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!
-
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
I remember when this place was cool.
-
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!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
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!
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
RMAN?
Never heard of it.
MH
I remember when this place was cool.
-
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.
OCP 8i, 9i DBA
Brisbane Australia
-
Your setup supports 4GB datafiles.
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|