zhu chao apparently said,on my timestamp of 13/12/2005 5:35 PM:
The matrix above is out of date. At least for Ext3Filesystem, single file can be much larger than 2gb. And solaris should only support 4k/8k blocksize?(even for vxfs).
Yes, but be careful: until 10g, Oracle supports only 32Gb max file size, no matter what the file system might support or its block size be. I believe the same applies to raw. All to do with maximum addressability inside a file in a tablespace. It's in the database limits doco.
On 12/10/05, *dba1 mcc* <mccdba1@xxxxxxxxx <mailto:mccdba1@xxxxxxxxx>> wrote: Does there has way like SUN Solaris I can create file system blocksize like 128K?
You probably can in Solaris, but never, ever, create a file system with blocksize larger than the one in the database! Under penalty of much increased physical I/O for anything other than a FTS or index FFS.
-- Cheers Nuno Souto in rainy Sydney, Australia dbvision@xxxxxxxxxxxx -- http://www.freelists.org/webpage/oracle-l