Re[2]: That crazy CBO.....

Jonathan Gennick wrote:

>I'd argue that Oracle should fix it. One shouldn't have to
>bother with something as cumbersome as 10046 trace just to
>see an execution plan. I don't even like having to query the
>plan table (or use dbms_xplan) from SQL*Plus. The front end
>should do all that crud for me. Just MHO.

You mean, like OEM? :)

I smiley, but actually I use it all the time, even though explain plain sometimes lies like a dog. Yes, Oracle should fix all those things. Until Oracle fixes _all_ those things, any self-tuning-database marketspeak is suspect, to say the least.

http://www.garry.to

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