Re: [newbie] bind variables

Franz,
Tom Kyte has a couple of scripts that will show you if you are using bind variables.
http://asktom.oracle.com/pls/ask/f?p=4950:8:435887118464616028::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1163635055580,

Also, If you do a Statspack report and you have a low Soft Parse %, then that can be an indication of the need to use bind variables.

"Franz" <franz_at_mail.com> wrote in message news:<q4%2b.268595$Ny5.8263211_at_twister2.libero.it>...
> Hi all,
> I'm using a SQL statement from inside a Java function.
> The statement is a PreparedStatement, that is:
>
> select * from table1 where field1 = ?
>
> then in the code I set at runtime "field1" with the desired value.
> Now my question is: will Oracle use bind variables when I issue a statement
> like
> this ? I'd like to avoid to have my statement re-parsed every time.
>
> A further question: how do you check on the DB that a statement has been
> parsed ?
>
> Thanks a lot
> Frank
Received on Wed Aug 27 2003 - 10:24:38 CDT