Do stored outlines work in Oracle 10.2.0.3?
Date: Sun, 15 Jun 2008 04:39:55 -0700 (PDT)
I am using 10.2.0.3 on HP UNIX 11i. I set cursor_sharing=exact.
I created a stored outline using:
alter session set create_stored_outlines='CUSTOM'; my sql_statement;
When I run the sql statement and verify in v$sql whether outline was used by looking at outline_category and yes outline is used.
But then I run dbms_stat on an underlying table and run my sql again,
my plan has changed which means outline was not used. This is really
baffling, if outline was used,
Plan should be same as what was produced when creating outline. Something is
I treied different values of cusror_sharing and none worked. Received on Sun Jun 15 2008 - 06:39:55 CDT