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 -> Re: what is the reason of design decision of bypassing the buffer cache for parallel query?

Re: what is the reason of design decision of bypassing the buffer cache for parallel query?

From: <sybrandb_at_yahoo.com>
Date: 1 Jun 2005 00:44:21 -0700
Message-ID: <1117611861.052862.250860@z14g2000cwz.googlegroups.com> 





Parallel query will only be used for full table scans. Blocks gotten by
full table scans are paged out immediately anyway.
The benefit you mention doesn't necessarily exist, depending on how
your system is being stressed.


I don't think there is any benefit to use parallel query for random
reads.



--
Sybrand Bakker
Senior Oracle DBA


Received on Wed Jun 01 2005 - 02:44:21 CDT












Original text of this message













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