Re: Slow SQL performance
From: Oxnard Montalvo <oxnard_at_carolina.rr.com>
Date: Mon, 21 Apr 2008 15:01:33 -0400
Message-ID: <22688551.1639901208804494009.JavaMail.root@cdptpa-web26-z02>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 21 2008 - 14:01:33 CDT