DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: datafile greater than 2GB

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    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!

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    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.

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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!

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    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.

  5. #5
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    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

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  7. #7
    Join Date
    Jan 2001
    Posts
    3,134
    RMAN?

    Never heard of it.

    MH
    I remember when this place was cool.

  8. #8
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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

  9. #9
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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
  •  


Click Here to Expand Forum to Full Width