Which two methods would you use to achieve this?

You plan to upgrade your production database from Oracle Database 11gto 12c. As part of
the upgrade, you want to introduce new indexes and materialized views. You have already
created atest system with Oracle Database 12c, having the same structure and data as the
production database, along with new schema objects to be added to the production database.
You want to identify regressed SQL statements, if any, which may have been caused by
schema changes and the change in the optimizer version. Which two methods would you
use to achieve this?(Choose two.)

You plan to upgrade your production database from Oracle Database 11gto 12c. As part of
the upgrade, you want to introduce new indexes and materialized views. You have already
created atest system with Oracle Database 12c, having the same structure and data as the
production database, along with new schema objects to be added to the production database.
You want to identify regressed SQL statements, if any, which may have been caused by
schema changes and the change in the optimizer version. Which two methods would you
use to achieve this?(Choose two.)

A.
Create an SQL Tuning Set (STS) for the SQL statements on the production database and
submit as input to the SQL Tuning Advisor on the test database.

B.
Create an STS for the SQL statements on the production database and submit as input to
the SQL Performance Analyzer with theOPTIMIZER_FEATURES_ENABLEparameter
first set to11.2.0.1, and then to12.1.0.1on the test database.

C.
Generate an Automatic Workload Repository (AWR) compare periods report with
snapshots taken before and after schema changes on the test database.

D.
Capture the production database workload, replay it on the test system by using Database
Replay, and analyze by using the workload replay compare period report.

E.
Create an STS for the SQL statements on the production database and submit as input to
the SQL Access Advisor on the test database.

F.
Create an STS for the SQL statements on the production database before and after
changes and submit as input to the SQL Performance Analyzer on the test database.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


vasya

vasya

imo B and E