Thinking logically - Oracle was pushing everyone to CBO but Oracle
developers themselves were not ready to switch to CBO in 9i. In 10g
they got ready for CBO on dictionary tables and this is why you need
statistics now.

2006/6/15, dba1 mcc <mccdba1@(protected)>:
> I just don't understand why 10Gr2 need collect
> statistics on "sys", but 9ir2 don't need.

--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l