Re: figure out which queries are not using bind variables?

  • From: "Egor Starostin" <egorst@xxxxxxxxx>
  • To: ryan_gaffuri@xxxxxxxxxxx
  • Date: Thu, 4 May 2006 23:48:19 +0400

Oracle 10g. Does Oracle track which queries do not use bind variables?
Thanks for specifying Oracle version.
Try something like this:
select sql_text from v$sqlarea where hash_value not in (select
hash_value from v$sql_bind_capture);


-- Egor http://www.oracledba.ru -- //www.freelists.org/webpage/oracle-l


Other related posts: