Re: Way to create large block size under LINUX for ORACLE dataabase??

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


Other related posts: