RE: Another question about Stored outlines not being used

Allen,

Yes I checked v$sql_plan, and the new outline path actually is from the current explain plan WITHOUT any hint and it uses the index instead of FTS as compared to the plan in V$SQL_PLAN.  And that is what we used to create the store outline.

Thanks for the reply.

---

From: "Allen, Brandon" <Brandon.Allen@OneNeck.com>
Reply-To: Brandon.Allen@OneNeck.com
To: <binhpham15@hotmail.com>,<oracle-l@freelists.org>
Subject: RE: Another question about Stored outlines not being used
Date: Wed, 11 Apr 2007 09:18:28 -0700

Maybe the index isn't valid so Oracle is ignoring the hint, e.g. it's columns aren't specified in the WHERE clause of the query?  Are you sure you flushed the old plan out of the shared pool?  You should get "no rows selected" when you "select count(*) from v$sql_plan where hash_value = <outline_query_hash_value>;"  There are a couple notes on Metalink about "why my hint is being ignored" and "why isn't my index being used" - don't recall the numbers off the top of my head, but you might want to look them up.

 

Regards,

Brandon

---

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Binh Pham

My previous questions about stored outlines getting few answers from people on this list.  However, I'm trying again.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.