Re: finding SQL that doesn't have bind variables

From: GG <>
Date: Fri, 16 Mar 2012 18:31:28 +0100
Message-ID: <>

W dniu 2012-03-16 18:13, Dba DBA pisze:
> that is a very good idea. so look for digits that have a space between them
> and a character. Anyone know how to do that with a regular expression? I
> just recently started digging into them.
> so if i have

What about searching for sql text not like ':1' or not like ':bv1' ? Second option is look for queries with same plan hash value but different sql hash value ,
its kind of indirect but maybe worth try. Regards
Received on Fri Mar 16 2012 - 12:31:28 CDT

Original text of this message