Re: Slow SQL performance

From: Oxnard Montalvo <>
Date: Mon, 21 Apr 2008 15:01:33 -0400
Message-ID: <22688551.1639901208804494009.JavaMail.root@cdptpa-web26-z02>

I am not sure that is the case ... assuming using dbms_stats the "no_invalidate" option defaults to TRUE in 10 but FALSE in 9.

So if you use the default in 10 what you are saying is "Do not Invalidate the SQL in the shared pool"

if you want to dump all SQL in the Shared Pool alter system flush shared_pool;
or something pretty close to that

Received on Mon Apr 21 2008 - 14:01:33 CDT

Original text of this message