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

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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Egor Starostin Sent: Thursday, May 04, 2006 3:48 PM
To: ryan_gaffuri_at_comcast.net
Cc: oracle-l_at_freelists.org
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
--
http://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
==============================================================================

--
http://www.freelists.org/webpage/oracle-l