Guess you are talking abuot SQL Plan Baseline feature in 11g? I have some experiences: In 10g,I have used SQL Tuning Set to capture the 10g SQL Plan before upgrade: example: http://oracle-study-notes.blogspot.com/2012/04/capture-current-10g-execution-plans.html In 11g, I have created a SQL Plan Baseline from the 10g plan for a problem sql after upgrade : example:http://oracle-study-notes.blogspot.com/2012/07/using-sql-plan-baseline-to-ensure-10g.html Regards, Denis -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams Sent: Friday, April 26, 2013 9:12 AM To: oracle-l@xxxxxxxxxxxxx Subject: Moving 10g SQL plans into 11g List, I'm planning an upgrade from 10.2.0.4 to 11gR2. I'm concerned that some SQL plans will not behave as they currently do. This is a critical OLTP system supporting manufacturing. Easily crippled by a bad query. 11g has a method to move SQL plans from 10g to 11g. Has anyone used this? Dennis Williams -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l
