Re: Using Bind Variables with Cold Fusion and Oracle

<OakRogbak_erPine_at_yahoo.com> wrote in message news:13fdc9b4.0307020959.79a7c322_at_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?

well the sql_text column holds the actual sql_text so you could look at that.

A neat tip I picked up today is to group entries in v$sql by persistent_mem since statements identical except for literals tend to take the same memory.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************