Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle CBO query cost - retrieve value?

Re: Oracle CBO query cost - retrieve value?

From: DA Morgan <>
Date: Tue, 09 Oct 2007 08:50:12 -0700
Message-ID: <>

cleveridea wrote:

> On Oct 8, 3:27 pm, joel garry <> wrote:

>> On Oct 8, 12:09 pm, cleveridea <> wrote:
>>> On Oct 7, 4:37 pm, DA Morgan <> wrote:
>>>> wrote:
>>>>> Urm, Morgan, you didn't really think that was a question on syntax,
>>>>> did you?
>>>>> To the OP, don't look at cost. It is not for consumption by the end-
>>>>> user.
>>>>> You have a bind-variable peeking problem.
>>>>> Construct say 3 different cursors each with a different stabilised
>>>>> plan based on selectivity of the inputs, and call the appropriate
>>>>> cursor based on the input variable. Or reject it altogether.
>>>>> Comes down to: know your data.
>>>> Given the syntax error ... you are assuming that what you are seeing
>>>> is the real statement. I'm not willing to make that assumption.
>>>> The OP has now stated: "I anonymised & simplified the query data
>>>> incorrectly" so, given that it has been simplified, the real issue
>>>> may bear no relationship to what has been posted.
>>>> To the OP. Anonymizing, ok, rename the tables and columns if you wish.
>>>> But simplifying makes the exercise meaningless.
>>>> --
>>>> Daniel A. Morgan
>>>> University of Washington
>>>> (replace x with u to respond)
>>>> Puget Sound Oracle Users
>>> Daniel why don't you just ignore such posts that are so problematic to
>>> you? Why do you continually waste everyone's time posting how bad
>>> other people's posts are
>> Not answering for Daniel, but rather in general:
>> It's not a waste of time to present feedback on a question. A bad
>> question helps no one, and may indeed hinder people by both being a
>> bad example for others to emulate and propagating misinformation or
>> bad assumptions. There are such things as bad questions, that's why
>> there are postings on how to ask a good question (like
>> appreciated). There may be better ways to present constructive
>> criticism, but that applies to all of us. Rather than telling Daniel
>> to ignore such posts, try giving him better ways of answering them.
>> He's been around here a long time, so perhaps he's set in his ways,
>> but he's also an instructor, and presumably receptive to usable
>> suggestions on how to get good information propagated.
>> jg
>> --
>> is bogus.
>> "Give a Filipino a dog and you've fed him for a day. Teach a Filipino
>> to hunt dogs and you've fed him for a lifetime." - Ralph Garman (after
>> reporting stories about PETA wanting Britney's dogs taken away and
>> Filipinos upset about a "Filipino medical school" line on Desperate
>> Housewives). He also voices a dog on Family Guy, most recently seen
>> eating discarded human legs.
> (continuing off-topic) I can appreciate that providing feedback for
> bad questions is a good thing to do.  And, I can appreciate that
> everyone can benefit from honing their own skills, myself included -
> since my posting was just as much a crude criticism and waste of time
> for everyone.  I just disliked seeing yet another visceral and petty
> posting, and it hacked me off.
> So, I apologize for being guilty of the exact thing I implicated
> Daniel.  If I have a specific personal *and* constructive criticism
> for anyone, I will direct such in an appropriately private fashion in
> the future.

No need to apologize and I hope you take my response to your question in the light-hearted manner in which it was intended.

In the Oracle OTN forums I would venture that 90+% of those posting do not include version numbers when it is impossible to give a good answer without knowing whether they are on 7.0.12 or In some cases the difference between and can make a big difference.

When we are not seeing real code, real error messages, etc. we are all just guessing and what I am trying to do is educate those asking questions so that, in the future, they will ask better questions.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Oct 09 2007 - 10:50:12 CDT

Original text of this message