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

Home -> Community -> Usenet -> c.d.o.server -> parallel read and buffer cache

parallel read and buffer cache

From: utkanbir <hopehope_123_at_yahoo.com>
Date: 1 Sep 2004 07:22:31 -0700
Message-ID: <f6c90ebe.0409010622.3ed5697d@posting.google.com>


Hi Gurus ,

a select statement runs parallel bypasses the buffer cache and uses pga instead .

if the above statement is correct , than a datawarehouse (like me) which uses mostly parallel queries does not take any advantage of having a large buffer cache , does it?

is this how it works?

Kind Regards,
tolga Received on Wed Sep 01 2004 - 09:22:31 CDT

Original text of this message

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