Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Max datafile size in AIX5.2L

Re: Max datafile size in AIX5.2L

From: Nuno Souto <dbvision_at_optusnet.com.au>
Date: Wed, 30 Jun 2004 00:36:27 +1000
Message-ID: <40E17E6B.7000509@optusnet.com.au>


Michael Boligan apparently said,on my timestamp of 30/06/2004 12:20 AM:

> AIX has the capabillity to support files over 2GB. Ask your system admin
> to turn on large files enabled. Or man mkfs
> HTH,
> Mike.

>
> "Prem Khanna J" <premj_at_rediffmail.com>
> Hi All,
> The env. is oracle 9.2.0.4 & AIX 5.2L (64 bit)
>
> What is the safe limit for maximum datafile size ?
> I see lot of articles about 2GB limitation.

Wasn't there a warning a coupla days ago or so about AIX using 128Kb I/O block size (when using DIO?) for files >2Gb?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_optusnet.com.au
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jun 29 2004 - 09:32:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US