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

From: Scott Heisey <>
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


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

From: [] On Behalf Of Daniel Fink
Sent: Monday, March 01, 2010 8:57 AM
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

Oracle Blog

Lost Data?

-- Received on Mon Mar 01 2010 - 12:46:25 CST

Original text of this message