Re: Moving 10g SQL plans into 11g
From: Denis <denis.sun_at_yahoo.com>
Date: Sun, 28 Apr 2013 06:32:50 -0700 (PDT)
Message-ID: <1367155970.15928.YahooMailNeo_at_web122001.mail.ne1.yahoo.com>
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,
Date: Sun, 28 Apr 2013 06:32:50 -0700 (PDT)
Message-ID: <1367155970.15928.YahooMailNeo_at_web122001.mail.ne1.yahoo.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams
Sent: Friday, April 26, 2013 9:12 AM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Sun Apr 28 2013 - 15:32:50 CEST