Re: Fwd: Re: Really deleting system statistics?

I thought Oracle would use the IO model in absence of system statistics (default behaviour in 9i) ?

thanks
amit

Peter Alteheld wrote:

>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
>
>
>

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