Re: Help interpreting TKPROF output

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Sun, 9 Nov 2003 22:19:25 -0500
Message-ID: <0didnTYaD7BrnjKiRVn-sg@comcast.com>

"Geomancer" <pharfromhome_at_hotmail.com> wrote in message news:cf90fb89.0311091846.2f25d397_at_posting.google.com...
> > but these would have no affect if Siebel has optimizer mode set to RULE,
no?
>
> Yes, but sometimes it is left to the default optimizer_mode=choose.

Yes, I suppose we would not want to trust them -- but if hey're designing for RULE, think I'd set it the init.ora RULE and not worry about the stats anymore (hopefully they're the only application in the instance)

>
> I wonder what Siebel will do when 10g comes around with no RBO?

Sounds like they'll upgrade to 8.0 ;-) Received on Sun Nov 09 2003 - 21:19:25 CST