Do stored outlines work in Oracle

From: <>
Date: Sun, 15 Jun 2008 04:39:55 -0700 (PDT)
Message-ID: <>

I am using 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
Definitely wrong.

I treied different values of cusror_sharing and none worked. Received on Sun Jun 15 2008 - 06:39:55 CDT

Original text of this message