Check v$SQL ? From the definition of V$SQL :OUTLINE_CATEGORY VARCHAR2(64) If an outline was applied during construction of the cursor, then this column displays the category of that outline. Otherwise the column is left blank.
At 12:50 AM Saturday, richa03@xxxxxxxxx wrote:
10.2.0.3 Linux x86-64 Is there any way to determine if a SQL statement entered via SQL*Plus is using a stored outline other than the fact that the plan changes? -- //www.freelists.org/webpage/oracle-l
Hemant K Chitale http://hemantoracledba.blogspot.com -- //www.freelists.org/webpage/oracle-l