RE: /* SQL Analyze(2046, 1) */

From: Scott Heisey <oraracdba_at_yahoo.com>
Date: Mon, 1 Mar 2010 11:46:25 -0700
Message-ID: <003201cab96f$7f0bd230$7d237690$_at_com>



Dan are they using SQLT? SQLT runs some SQL's as part of that package that have this hints so you can use them in the where clause when querying v$sql. I have not seen this one but I have seen similar ones in SQL

Scott

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daniel Fink
Sent: Monday, March 01, 2010 8:57 AM
To: oracle-l_at_freelists.org
Subject: /* SQL Analyze(2046, 1) */

In looking at a performance problem in a recently inherited db (11.0.7 on Solaris9) and came across some statements with this comment as the leading text. The application team says they have no idea about the code. I'm wondering if it is coming from the SQL Tuning Advisor...



Daniel Fink

OptimalDBA http://www.optimaldba.com
Oracle Blog http://optimaldba.blogspot.com

Lost Data? http://www.ora600.be/
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 01 2010 - 12:46:25 CST

Original text of this message