Prev: Work from anywhere, Get payout daily.
Next: Memory problems, Oracle 10, Win 2003 (32 bit)
From: zigzagdna on 15 Jun 2008 07:39
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
Definitely wrong.

I treied different values of cusror_sharing and none worked.
From: zigzagdna on 15 Jun 2008 16:53
On Jun 15, 7:39 am, zigzag...(a)yahoo.com wrote:
> 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
> 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.
 | 
Pages: 1
Prev: Work from anywhere, Get payout daily.
Next: Memory problems, Oracle 10, Win 2003 (32 bit)