RE: Another question about Stored outlines not being used
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: <binhpham15@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
