DBMS_OUTLN.create_outline
487405Jan 4 2008 — edited Jan 8 2008I'm trying to use stored outlines(never used them before) since I want to use the same execution plan, main reason being issues with bind peeking, stats collection on these huge partition tables takes longer and execution plan differs drastically and performance degrades.
The queries from the middleware all use bind variables. Hence I wanted to use
BEGIN
DBMS_OUTLN.create_outline(
hash_value => 3909283366,
child_number => 0,
category => 'SCOTT_OUTLINES');
END;
/
But then when I use the query to see the created outline, I get nothing.
SELECT name, category, sql_text FROM user_outlines WHERE category = 'SCOTT_OUTLINES';
Could someone point me in the right direction please.