Re: Slow SQL performance

  • From: Oxnard Montalvo <oxnard@xxxxxxxxxxxxxxx>
  • To: piontekdd@xxxxxxxxx
  • Date: Mon, 21 Apr 2008 15:01:33 -0400

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: