Fwd: Re: Really deleting system statistics?

  • From: Peter Alteheld <palteheld@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 11 May 2005 15:47:20 +0200 (CEST)

Hi,
 
I wanted to learn about the cpu model behaviour when no system statistics are 
available. That is different from the io model.
 
Peter
amit poddar <amit.poddar@xxxxxxxx> wrote:
How about settting

_optimizer_cost_model to *io

SQL> alter session set "_optimizer_cost_model"=abc;
ERROR:
ORA-00096: invalid value ABC for parameter _optimizer_cost_model, must 
be from
among choose, io, cpu


                
---------------------------------
Gesendet von Yahoo! Mail - Jetzt mit 1GB kostenlosem Speicher

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

Other related posts: