Home » Oracle » 1z0-060 » What should you use to achieve this?
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
A. Database replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository compare reports
Correct Answer: D
Explanation/Reference:
You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include:
Database upgrades
Configuration changes to the operating system, hardware, or database
· Database initialization parameter changes
Schema changes, such as adding new indexes or materialized views
· Gathering optimizer statistics
SQL tuning actions, such as creating SQL profiles
http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT961
Download Printable PDF. VALID exam to help you PASS.
|
|