You perform the followingactivities during the database upgrade from Oracle Database 10g to Oracle Database 11g;-> Captu

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You perform the followingactivities during the database upgrade from Oracle Database 10g to Oracle Database 11g;-> Captu

Post by answerhappygod »

You perform the followingactivities during the database upgrade from Oracle Database 10g to Oracle Database 11g;-> Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade-> Load these plans from the STS into the SQL plan baseline immediately after the upgradeWhat is the reason for performing these activities?

A. To minimize plan regression due to the use of a new optimizer version
B. To completely avoid the use of new plans generated by a new optimizer version
C. To prevent plan capturing when the SQL statement is executed after the database upgrade
D. To keep the plan in the plan history so that is can be used when the older version of the optimizer is used
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply