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

Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: Re: Really deleting system statistics?

Fwd: Re: Really deleting system statistics?

From: Peter Alteheld <palteheld_at_yahoo.de>
Date: Wed, 11 May 2005 15:47:20 +0200 (CEST)
Message-ID: <20050511134720.76641.qmail@web26503.mail.ukl.yahoo.com>


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_at_yale.edu> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 11 2005 - 09:51:52 CDT

Original text of this message

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