 | |
Do stored outlines work in Oracle 10.2.0.3?
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Do stored outlines work in Oracle 10.2.0.3? -
06-15-2008
, 06:39 AM
#2
| |||
| |||
|
|
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. |
work.
#3
| |||
| |||
|
|
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. |
work.
#4
| |||
| |||
|
|
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. |
work.
#5
| |||
| |||
|
|
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. |
work.
#6
| |||
| |||
|
|
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. |
work.
#7
| |||
| |||
|
|
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. |
work.
#8
| |||
| |||
|
|
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. |
work.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.