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!
Received on Mon Jun 07 2004 - 04:13:11 CDT
