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