-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|