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