Using Bind Variables with Cold Fusion and Oracle

From: OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply <OakRogbak_erPine_at_yahoo.com>
Date: 2 Jul 2003 10:59:26 -0700
Message-ID: <13fdc9b4.0307020959.79a7c322@posting.google.com>

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?

Thanks,
Roger Received on Wed Jul 02 2003 - 12:59:26 CDT