DBA GENESIS

  • Courses

  • Certification

  • Contact

  • Members

  • More

    Use tab to navigate through the menu items.

    Book a mock interview and get instant feedback - Learn More

    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Joy Stick
    Nov 22, 2021

    Need to copy SQL plan from one Env to another EnV ..

    in Oracle Performance Tuning

    Appl Team told that a SQL which is running well on DEV env and same SQL performance is bad on Prod. Now they want to apply DEV env Explain Plan to Prod ENV SQL Query.


    What is the best approach to copy Explain Plan from one env to another env (Dev to Prod) ?


    Version 19c


    Thanks in Advance

    2 answers0 replies
    2 Comments

    Share Your ThoughtsSign up to leave a comment.

    S
    Sachin Bonde
    Dec 27, 2021
    •

    I prefer to run coe_xfr_sql_profile.sql on source DB with input sql_id and Plan# value and which creates .sql file that can copy and run on target DB.


    Also we can get outline data of sql query from source DB and run the query on target db with outline data to get that plan on target DB but this can be done if issue with select statement.

    1

    A
    Arun Kumar
    Dec 22, 2021
    •

    Here is a great article that demonstrates how to copy the SQL plan: https://docs.rackspace.com/blog/transfer-sql-plans-by-using-sql-plan-baseline/

    1
    2 comments
    Similar Posts
    • How to import data from Excel to the Oracle Database using SQL Developer?
    • How to determine the optimal degree of parallelism to expedite datapump
    • FLushout bad execution plans only

    support@dbagenesis.com

    • Facebook
    • Instagram
    • Twitter
    • YouTube

    © 2023 Biggest Database Forum by DBA Genesis