Exam 1z0-053 topic 15 question 59 discussion

Actual exam question from Oracle's 1z0-053

Question #: 59
Topic #: 15

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURES_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements. What would you do with these SQL statements?

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B. Capture the plans from the previous version using STS and then load them into the stored outline.
C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

Show Suggested Answer

Suggested Answer: C 🗳️
The SQL management base (SMB) is a part of the data dictionary that resides in the SYSAUX tablespace. It stores statement logs, plan histories, SQL plan baselines, and SQL profiles.
Parameters Relating to Stored Outline Migration:
✑ OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES, Enables or disables the automatic recognition of repeatable SQL statement and the generation of SQL plan baselines for these statements.
✑ OPTIMIZER_USE_SQL_PLAN_BASELINES, Enables or disables the use of SQL plan baselines stored in SQL Management Base.

by thuthuysphn58 at April 4, 2025, 8:21 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!