Stored outline not being used all the times...

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Wed, 06 Dec 2006 21:09:52 +0000
Message-ID: <BAY103-F1376F44831013E36C7D39D2DD0@phx.gbl>

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://www.freelists.org/webpage/oracle-l Received on Wed Dec 06 2006 - 15:09:52 CST