Oracle-L: RE: blocksize on AIX

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 02 Oct 2003 11:14:28 -0800
Message-ID: <F001.005D1D68.20031002111428@fatcity.com>

We use 8192 on AIX and have no problems. The AIX block size is 512 so I know it is advisable to have a multiple of 512, other than that I know of no other caveat.

Ruth
  -----Original Message-----
  From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of   Hans de Git
  Sent: Wednesday, October 01, 2003 4:24 AM   To: Multiple recipients of list ORACLE-L   Subject: blocksize on AIX

Hi all,

I've read on ixora.com.au and other sites that the optimal block size for AIX is 4K, because JFS pages are 4K also.

Has anyone of you ever experienced performance problems on AIX due to a larger blocksize? What exactly are the 'read ahead' issues and cpu problems
regarding double buffering etc. Are there any alternatives, other than moving to raw volumes?

HTH,
Hans

MSN Zoeken, voor duidelijke zoekresultaten! http://search.msn.nl

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net   --
  Author: Hans de Git
    INET: hansdegit_at_hotmail.com

  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
  San Diego, California        -- Mailing list and web hosting services
  ---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------