首页计算机考试Oracle认证
(单选题)

You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? ()

Ato minimize plan regression due to the use of a new optimizer version

Bto completely avoid the use of new plans generated by a new optimizer version

Cto prevent plan capturing when the SQL statement is executed after the database upgrade

Dto keep the plan in the plan history so that it can be used when the older version of the optimizer is used

正确答案

来源:www.examk.com

答案解析

快考试在线搜题