Re: parallel query

Hi Brian,

How to minimize the physical reads? This query joins three tables and each table has almost 7 million rows?

Thanks,
Prasath.

Brian Peasland wrote:

> You have 331,539 physical reads which is most likely contributing more
> to performance problems than 2 sorts to disk. Are you sure that you are
> looking at the correct location for your performance problem?
>
> If you have WORKAREA_SIZE_POLICY set to auto and your
> PGA_AGGREGATE_TARGET defined, you can use the and V$PGA_TARGET_ADVICE
> views to tune your PGA_AGGREGATE_TARGET parameter.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
Received on Tue Jul 11 2006 - 04:35:52 CDT