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 01:45:51 +1000
Message-ID: <40E18EAF.7000608@optusnet.com.au>


Byron Pearce apparently said,on my timestamp of 30/06/2004 1:13 AM:

> I think you're referring to the post I put out on the list Friday. It
> was from an IBM document on Oracle Performance Tuning that said:

Bingo. Thanks. Very interesting post.

> The big file attribute increases the minimum DIO transfer size
> (diocapbuf.dio_min returned by the finfo system call) from 4K to 128K,

I'm just wondering: can anyone with access to AIX do a trial of this? C program, open a file and get the info with finfo() for this
parameter. With/without DIO so we can be sure?

> experience or comments on it. I have not been able to wrangle resources
> to try and run some empirical tests at this point, but there is quite a
> bit of internal discussions (not heated just yet) starting to take place
> as a result of the doc.

I'll bet! :)

-- 
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 - 10:44:07 CDT

Original text of this message

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