Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: Re: Really deleting system statistics?
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 11 2005 - 09:51:52 CDT
![]() |
![]() |