OCP 1Z0 053 233

233.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_FEATURE_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. 
Answer: C

http://docs.oracle.com/cd/E11882_01/server.112/e41573/optplanmgmt.htm#PFGRF95122

15.6 SQL Management Base

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. To allow weekly purging of unused plans and logs, the SMB uses automatic space management.

You can also add plans manually to the SMB for a set of SQL statements. This feature is especially useful when upgrading the database from a version before Oracle Database 11g because it helps to minimize plan regressions resulting from the use of a new optimizer version.

Because the SMB is located entirely within SYSAUX, the database does not use SQL plan management and SQL tuning features when this tablespace is unavailable.