Re: Does Optimizer use P.A.T to calculate cost..?

From: <mccmx_at_hotmail.com>
Date: 26 Oct 2006 06:25:50 -0700
Message-ID: <1161869150.705772.305510@i42g2000cwa.googlegroups.com>

> pga_aggregate_target indirectly controls several other parameters,
> including sort_area_size and sort_area_retained_size. sort_area_size
> and sort_area_retained_size influence the calculated cost of perfoming
> full table scans.

Thats what I thought....

> Time to start investigating what is happening, a 10046 trace at level 8
> will help. Also, take a look at the output of this SQL statement:

I've added a 10046 for tonights run...

Thanks for your help.

Matt Received on Thu Oct 26 2006 - 08:25:50 CDT