Re: Using Bind Variables with Cold Fusion and Oracle

OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply wrote:
> Hi,
> I want to make sure our Cold Fusion developers are using bind
> variables to reduce the amount of parsing required on their SQL.
>
> What do I look for in their code to identify this?
>
> Also, is there other ways as well? I.E. would something in a TOAD SGA
> trace show me that something is being parsed too much. Perhaps the
> "Executions" or "Parse Calls" fields on the SGA Trace page are related
> to this.
>
> Is there anything shown in the V$SQLAREA or V$SQLTEXT views that show
> me any indication of the use of bind variables?

Take a look at:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1163635055580

Cheers,
Dave

>
> Thanks,
> Roger
Received on Wed Jul 02 2003 - 16:02:46 CDT