omlet v4 wrote:
> Martin Burbridge <pobox002_at_bebub.com> wrote in message news:<Xns94FBD78B584D3pobox002bebubcom_at_204.127.204.17>...
>
>>amjadd_at_uop.edu.jo (omlet v4) wrote in
>>news:604b7892.0406010424.7fff3994_at_posting.google.com:
>>
>>
>>>Martin Burbridge <pobox002_at_bebub.com> wrote in message
>>>news:<Xns94F99E03A3AC3pobox002bebubcom_at_204.127.199.17>...
>>>
>>>>amjadd_at_uop.edu.jo (omlet v4) wrote in
>>>>news:604b7892.0405290545.1b3fb9df_at_posting.google.com:
>>>>
>>>>
>>>>>Ed Stevens <nospam_at_noway.nohow> wrote in message
>>>>>news:<4269b012v3vns4nputqbo4g5sm8pskrhnl_at_4ax.com>...
>>>>>
>>>>>>On 26 May 2004 03:19:27 -0700, amjadd_at_uop.edu.jo (omlet v4) wrote:
>>>>>>
>>
>> <snip>
>>
>>>>>>4) "Set the following three init.ora parameters to: cursor_sharing
>>>>>>= force . . . " HONK! Wrong answer! If I do that, my acess
>>>>>>plans change, quite possibly for the worse.
>>>>>>
>>>>>>I don't consider myself an expert in this field, so if even I
>>>>>>could find problems without even opening the product . . .
>>>>>
>>>>>Ed,
>>>>>
>>>>>I doubt you know anything about cursor_sharing or access plans.
>>>>>
>>>>
>>>>And you would? I know exactly what cursor sharing force does. It
>>>>turns all literals in your select statement into bind valiables
>>>>before they are parsed, optimized and executed. And that is all
>
>
> bind valiables?! -- I suggest you go back to school with zoe and annica.
> May thy be better that thou!
"I don't care what the newspapers say about me...so long as they spell
my name right."
P.T. Barnum (paraphrased)
Cheers
TD
Received on Mon Jun 14 2004 - 23:39:00 CDT
