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

  • From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Oct 2004 10:34:14 -0700

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.


Other related posts: