Re: How to tell if bind variables are being used?

From: Daniel Nichols <daniel_at_NOSPAMrdnichols.com>
Date: Sat, 20 Sep 2003 12:49:04 +0000 (UTC)
Message-ID: <q5jomv0cich4v452orfh4vsr3f3oggrdsj@4ax.com>

On 19 Sep 2003 10:33:01 -0700, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:

>Are there any scripts that you can use to determine whether
>applications are using bind variables?
>

Just look in v$sqlarea - if you can see your data in you SQL WHERE clauses or INSERT statements you are using literal SQL and are not using bind variables. If you see reference to :1, :2, etc you are using bind variables.

>also are there any scripts to determining whether people are
>committing too frequently?

This is good surely? Received on Sat Sep 20 2003 - 07:49:04 CDT