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: Oracle 9.2 PGA_Aggregate_target and a statistics question

Re: Oracle 9.2 PGA_Aggregate_target and a statistics question

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Thu, 11 Jul 2002 17:49:57 +0100
Message-ID: <VGiX8.1475$zX3.1030@news.indigo.ie>


Pete, Jonathan, thanks for the swift and excellent answers !

Followups :

  1. The 5/30 rule : Is that a hardcode or is it tunable ?
  2. Can I therefore assume that 5% (or 30 %) of PAT will be used as the relevant inputs into the query optimization process and would this be PAT or delta-PAT ?

trying some numbers assume 4GB or memory and 1G SGA Give the OS 512MB

-> PAT = 2.5G

-> 5% PAT = 125M
Which is not bad - a lot of stuff could fit in there ..

However, for a large sort > 125M there does not seem to be a facility to fast...

Whoops. just found WORKAREA_SIZE_POLICY ....

knock it to manual when we need a huge chunk to do something fast like a big index ?

One presumes even if in WAP is in manual and PAT is set then we still cannot exceed PGA_AGGREGATE_TARGET.

Food for thought all right....

Thanks again

T| Received on Thu Jul 11 2002 - 11:49:57 CDT

Original text of this message

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