Oracle-L: OS or disk caching with Oracle direct I/O

From: Gilles PARC <gparc_at_online.fr>
Date: Fri, 23 May 2003 13:23:03 -0800
Message-ID: <F001.005A1E72.20030523132303@fatcity.com>

Hi listers,

reading Oracle 9i Database Performance Tuning Guide and reference
(volume 2), I found an advice on page 16-3 regarding the
usefulness of Unix buffer cache and/or disk controller cache for Oracle operations that bypass the SGA such as PQ or read/write on temp tablespaces.
They don't say why but maybe it relates to read ahead mechanism.

Has anybody implement this strategy ?
Any comment ?

Gilles

Gilles Parc

carpe diem !!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gilles PARC
  INET: gparc_at_online.fr

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).

Received on Fri May 23 2003 - 16:23:03 CDT