What does v$SQL_SHARED_CURSOR show? Also remember that outlines will follow
cursor sharing rules; if you expect SIMILAR cursors to be shared, the
outline must be created with cursor_sharing = SIMILAR. If the queries are
exactly the same and still not being shared, hopefully the view will help
identify the reason.
On 12/6/06, Binh Pham <binhpham15_at_hotmail.com> wrote:
>
> I have a stored outline that has been indicated as being used ( in v$sql,
> column outline_category = PROD). However, in V$SQL_PLAN it shows a
> different plan than in the stored outline and also when I do explain of the
> SQL.
>
> We have the "alter system set use_stored_outlines = PROD" in our database
> startup trigger. We've also verified that other outlines are being used.
>
> Why was this one not using the stored ouline?
>
> I've noticed that in V$SQLAREA, this particular SQL has 5 invalidations
> and 6 loads. Even with the multiple invalidations and loads, Oracle should
> have used the outline.
>
> Any idea?
>
> Thanks.
>
> ------------------------------
> View Athlete's Collections with Live Search<http://g.msn.com/8HMBENUS/2731??PS=47575>--
> http://www.freelists.org/webpage/oracle-l
--
Charles Schultz
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 07 2006 - 13:05:04 CST
