I stand corrected, and thanks to Egor for pointing this out. Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Egor Starostin Sent: Thursday, May 04, 2006 3:48 PM To: ryan_gaffuri@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: figure out which queries are not using bind variables? > 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 ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- //www.freelists.org/webpage/oracle-l