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
    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
    Brisbane, Australia

    Solaris File sizes


    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


  3. #3
    Join Date
    Nov 2000
    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