Stored Outline
- From: Stalin <stalinsk@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Jul 2009 17:13:53 -0700
All,
We recently had a performance issue on a SQL for which we had stored
outlined defined for it. Wondering if oracle an skip stored outline by
any means.
We created outline using create_outline(hash_value, child_number) from
the child cursor in shared pool which had the good plan. And enabled
outline at system level and also to kept persistent across DB restart
via DB startup trigger.
The SQL in question is using bind variables though. Something along
the lines of "Select * from tablename where col1 = :1 and col2 = :2
and col3 = :3"
Thanks,
Stalin
Platform: 10gR2 (10.2.0.4), Sol10.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
