Moving 10g SQL plans into 11g
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 26 Apr 2013 08:11:45 -0500
Message-ID: <CAGRGHjwsM4p3rHcHVbRQJpp36tZhgYeoq+BPSo9pChToczHbgw_at_mail.gmail.com>
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?
Date: Fri, 26 Apr 2013 08:11:45 -0500
Message-ID: <CAGRGHjwsM4p3rHcHVbRQJpp36tZhgYeoq+BPSo9pChToczHbgw_at_mail.gmail.com>
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-lReceived on Fri Apr 26 2013 - 15:11:45 CEST