Re: Oracle 9.2 PGA_Aggregate_target and a statistics question

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