QUESTION 55-awr/workload performance

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 TuningAdvisor
C. SQL AccessAdvisor
D. SQL Performance Analyzer
E. Automatic Workload Repository compare reports
Correct Answer: D

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
References: http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT961

 

您的数据库支持联机事务处理(OLTP)应用程序。应用程序正在经历一些主要的模式更改，例如添加新的索引和物化视图。您需要检查这些更改对工作负载性能的影响。

你应该用什么来达到这个目的?

答:数据库重播

b . SQL TuningAdvisor

c . SQL AccessAdvisor

D. SQL性能分析器

自动工作负载存储库比较报告

正确答案:D

 

您可以使用SQL Performance Analyzer分析任何类型的系统更改对SQL性能的影响。常见的系统变更包括:—数据库升级

 

—操作系统、硬件或数据库的配置变更

—数据库初始化参数发生变化

—模式改变，如添加新的索引或物化视图

-收集优化器统计信息

—SQL调优操作，如创建SQL配置文件

引用:http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm # CNCPT961