Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help interpreting TKPROF output

Re: Help interpreting TKPROF output

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 09 Nov 2003 20:58:05 -0800
Message-ID: <1068440305.885296@yasure>


mcstock wrote:

>"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 ;-)
>
>
>

Anyone that buys Siebel, I'm not referring to the poor developers and DBAs that have to maintain it,
deserve what they get for a lack of due diligence. Perhaps they should have done some before they
laid down good money for projector-ware.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sun Nov 09 2003 - 22:58:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US