Moving 10g SQL plans into 11g

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 26 Apr 2013 08:11:45 -0500

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


Other related posts: