3 Replies Latest reply: Sep 9, 2013 1:42 PM by jgarry RSS

    SQL Plans - How to "select" a specific plan and copy it to another database?

    user130038

      Hi there,

       

      ENV: Oracle10gR2 (10.2.0.5.8) RHEL 5.8 64bit, OEM

       

      I have few questions regarding SQL Plans.

       

      1. One SQL can have several execution plans. How to select one of them and  make sure that Optimizer always uses the "selected" execution plan?
      2. Can I find out if there are any SQLs for which a certain execution plan has been "selected"?
      3. How to copy these "selected" execution plans to another database (which is copy of original database on a new server)?

       

      I have recently built a new server for a client with above config. I want to make sure that the SQL plans that are currently "selected" and in use in current database should be copied and used in the new database as well.

       

      Best regards