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

Thread: max file size on sun solaris

  1. #1
    Join Date
    Nov 2000
    Posts
    35
    what is the max file (datafile) size supported in sun solaris 2.x. I heard that 2GB is the max limit. can any body advice..thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Brisbane, Australia
    Posts
    46

    Solaris File sizes

    Ganjisb,

    According to Note 62409.1on Metalink:
    'There is a generic limit on the maximum Oracle datafile size of 4million Oracle data blocks. The exact limit is 4194303 * DB_BLOCK_SIZE.....'

    Solaris size limits are:
    Release Max file-system size Max OS File size
    < Solaris 2.6 1Tb (UFS) 2Gb
    >= Solaris 2.6 1Tb (40 bits) 1Tb

    Hope this helps

    Gerry

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    However, even with Solaris 2.6, you must enable LARGEFILES support when you create your filesystem or you will be stuck with 2G with a UFS file system. You will be stuck with a 2G-2K file size if you are using Veritas Filesystem without their LARGEFILES option.

    I personally don't like to create datafiles > 2G anyway. You get into situations where your data is more difficult to distribute. Of course, your mileage may vary....
    Jeff Hunter

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