Re: opinion solicited

Ed Stevens wrote:

> Yesterday I made a presentation to a group of our developers. The
> subject was the use of bind variables to reduce parsing and latch
> waits. I presented several demos based on those presented in Tom
> Kyte's book, and provided coding examples for several different
> programmnig environments.
>
> Later, one of the participants sent me a link to a website whose
> author acknowledged the problems of not using bind variables but
> appeard to be making a case that, in practice, the various coding
> environments (PL/SQL, java, etc.) took care of it for you. He (the
> wesite author) went on to give coding examples where - oh, gee, he was
> coding to use bind variables -- and saying that as long as you coded
> this way, the programming environment would just take care of it for
> you. I thought it was pretty misleading and gave the distinct
> impression to a casual reader that the programmer really didn't need
> to concern himself with the subject.
>
> Link is at http://www.rittman.net/archives/000832.html
>
> I'd be curious to hear other people's take.

Suffice it to say that whether the author of the article was clear, or not. Or whether the author is correct, or not.

Developers and DBAs had better be not only making sure they use bind variables ... they'd better be all of v_$open_cursor making sure that Oracle thinks they are using bind variables.

Daniel Morgan Received on Fri Jul 09 2004 - 17:45:32 CDT