Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: figure out which queries are not using bind variables?

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

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 4 May 2006 20:54:04 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF9413B@ENYC11P32005.corpny.csfb.com>


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
Received on Thu May 04 2006 - 14:54:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US