RE: /* SQL Analyze(2046, 1) */
- From: "Scott Heisey" <oraracdba@xxxxxxxxx>
- To: <daniel.fink@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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
Scott
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Daniel Fink
Sent: Monday, March 01, 2010 8:57 AM
To: oracle-l@xxxxxxxxxxxxx
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
