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

You can use statspack to catch the sqls running during snapshots. Then look at reports to see if bind variables are used or not.

HTH Guang

rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0309190933.5174470c_at_posting.google.com>...
> Are there any scripts that you can use to determine whether
> applications are using bind variables?
>
> also are there any scripts to determining whether people are
> committing too frequently?
Received on Sat Sep 20 2003 - 07:03:11 CDT