Re: finding SQL that doesn't have bind variables
From: GG <grzegorzof_at_interia.pl>
Date: Fri, 16 Mar 2012 18:31:28 +0100
Message-ID: <4F6378F0.6020507_at_interia.pl>
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
GregG
Date: Fri, 16 Mar 2012 18:31:28 +0100
Message-ID: <4F6378F0.6020507_at_interia.pl>
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
GregG
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 16 2012 - 12:31:28 CDT