Database Tuning (MOSC)

MOSC Banner

How can I use 'stored outline' for Execution Plan stability?

edited Nov 14, 2010 10:58PM in Database Tuning (MOSC) 8 commentsAnswered
 Hi,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center