Re: Do stored outlines work in Oracle

From: <>
Date: Sun, 15 Jun 2008 13:53:05 -0700 (PDT)
Message-ID: <>

On Jun 15, 7:39 am, wrote:
> 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.

I found they do not work when cusror_sharing=force, otherwise they work. Received on Sun Jun 15 2008 - 15:53:05 CDT

Original text of this message