The database application developers are planning to make some major schema changes such as
creating new indexes and materialized views. They want to check the net impact of these changes
on the workload performance. This activity has to be performed in the production database, so
they want only the query part of the data manipulation language (DML) statements to be executed
so that the side effects to the database or user data can be prevented. What should they use to
achieve this?
A.
Database Replay
B.
SQL Tuning Advisor
C.
SQL Access Advisor
D.
SQL Performance Analyzer
Its C.
SQL Access Advisor
The SQL Access Advisor is another major component of Oracle Database manageability. The SQL
Access Advisor takes a database workload as its input and recommends adding various access
structures. While generating recommendations, the SQL Access Advisor considers the impact of
adding new indexes, materialized views or materialized view logs etc. on data manipulation activities,
such as insert, update and delete, in addition to the performance improvement they are likely to
provide for queries.
developer is making changes to the schema, e.g. adding index, MV. so we are NOT using SQL Access Advisor to find out what index to add.
D is right. SPA can compare performance differences.