RE: /* SQL Analyze(2046, 1) */
Date: Mon, 1 Mar 2010 11:46:25 -0700
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
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
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...
http://www.freelists.org/webpage/oracle-l Received on Mon Mar 01 2010 - 12:46:25 CST