Hi Experts,
I have a Oracle package which runs at a scheduled time now one of the sql whcih is taking long time has been identified. I also have the good plan for the same sql from a awr.
Now my question is how to implement the good plan from awr.
I know about plan stability through
1 Stored outlines. In this case i have the enable the query_rewirte_enable=ture which i cannot chnage at session level as i cant change the code.
2 SQL Profiles : in this case how to generate the profile for that particular sql which i have identified from the awr
3 SQL plan management : as my db version is 10.2.0.4 i cannot use this feature as this is availabe with 11g
Regards