Re: Automatic Memory Management not allocating SGA resources - ??

On Feb 16, 4:17 pm, "BD" <robert.d..._at_gmail.com> wrote:
> On Feb 16, 12:35 pm, "BD" <robert.d..._at_gmail.com> wrote:
>
> > I'm confused about Automatic Memory Management.
>
> Follow-up - further discussion suggests that the issue is not that the
> cache is full, but that it's empty. Very few bind variables are being
> used, and it's likely that this is all about tuning the SQL for CBO
> versus RBO.
>
> Back to my Jonathan Lewis book...

If your system has an "Amazon-like workload" you might want to check into patch '10.2.0.3 patch 1' for MS win 32. The patchset 10.2.0.3 would have to first be applied to the oracle_home of interest.

-bdbafh Received on Sun Feb 18 2007 - 10:31:35 CST