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 -> How oracle determine the value of optimal_size and onepass_size to use during pga_aggregate_target

How oracle determine the value of optimal_size and onepass_size to use during pga_aggregate_target

From: <harvinder76_at_gmail.com>
Date: 16 May 2007 12:12:39 -0700
Message-ID: <1179342759.800120.187580@w5g2000hsg.googlegroups.com> 





Hi,



I am trying to understand the algorithm used by Oracle when using
pga_aggregate target and it looks like to get the information on
Expected_WorkAreaSize, Oracle already knows about the value of
optimal_size(cache size) and onepass_size so I was wondering how
oracle calculate this values. Also in the same white paper it is
mentioned that to sort the 10GB of input data Oracle only needs about
40MB for 1 pass but I thought to sort 10gb using 40MB bucket we need
lot of passes so how it calcuate this 40MB for onepass.



Thanks


--Harvinder
Received on Wed May 16 2007 - 14:12:39 CDT












Original text of this message













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