How can I use 'stored outline' for Execution Plan stability?
I have 2 schemas in the same db (vs. 10.2.0.4) , and I'm facing a big issue when I run a select (wich in the owner schema last 5 sec, while in the other almost 2 hours). In order to stabilize the exec. plan I've created an outline and try to using it:
Bellow are my steps:
alter session set create_stored_outlines=TRUE;
CREATE OUTLINE out_access FOR CATEGORY admin_nias_outlines on
select ....
alter session set create_stored_outlines=FALSE
select * from user_outlines where name='OUT_ACCESS'
select * from user_outline_hints where name='OUT_ACCESS'
ALTER SESSION SET query_rewrite_enabled=TRUE;