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

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: "'egorst@xxxxxxxxx'" <egorst@xxxxxxxxx>, ryan_gaffuri@xxxxxxxxxxx
  • Date: Thu, 4 May 2006 20:54:04 +0100

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


Other related posts: