Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question - dissimilar Plans in 'identical' environments

Re: Question - dissimilar Plans in 'identical' environments

From: BD <bobby_dread_at_hotmail.com>
Date: 20 Jul 2005 15:33:47 -0700
Message-ID: <1121898827.155041.319020@f14g2000cwb.googlegroups.com> 





Additional:



I am running dbms_stats.gather_db_stats in my test environment, but the
stats are being put into a table, not the dictionary. It's been
suggested that the new stats may be the factor, but I thought that in
order for the cbo stats to be used, the stats had to be imported into
the dictionary, and the cbo turned on in the init file.



Bleargh.
Received on Wed Jul 20 2005 - 17:33:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US