OCP-1Z0-053-V12.02-369题

最新推荐文章于 2017-11-10 15:54:00 发布

原创最新推荐文章于 2017-11-10 15:54:00 发布 · 6.5k 阅读

本内容遵循CC 4.0 BY-SA版权协议

870 篇文章

订阅专栏

796 篇文章

订阅专栏

本文详细介绍了SQL优化过程中的两个关键工具：SQL访问顾问和SQL调优顾问。通过分析SQL语句的工作量，SQL访问顾问提供全球性建议，包括缺失索引和实体化视图推荐；而SQL调优顾问则专注于单个SQL语句的调优，研究执行不佳的SQL语句并提供资源消耗方面的改进建议。

369.Which of the following identifies and creates an index to minimize the DB time for a particular SQL

statement?

A. The SGA Tuning Advisor

B. The SQL Access Advisor

C. The SQL Tuning Advisor

D. The Memory Advisor

Answer: C

答案解析：

下列哪项识别和创建索引，以尽量减少DB时间为特定的SQL语句?

SQL优化指导：分析各个 SQL 语句, 并建议 SQL 概要文件, 统计信息, 索引和重构的 SQL 以改善 SQL 性能。

SQL访问指导：评估 SQL 的全部工作量, 并建议索引, 分区和实体化视图, 它们将改善 SQL 工作量的总体性能。

The SQL Access Advisor allows the DBA to gather global recommendations for a workload. The SQL Tuning

advisor is more granular, tuning a single statement.

The main functions of the SQL Access advisor is to recommend missing indexes and materialized views, but

a comprehensive task analysis will also create SQL Profiles that can be used within the SQL Tuning advisor.

The DBA defines the SQL used in the SQL Access Advisor task, and can choose current SQL, a user-defined

set of SQL, a historical workload, or a hypotheticalworkload.

A hypothetical workload is very useful because the DBA need-only specify the tables that participate in the

queries, and the SQL Access Advisor gathers the appropriate SQL statements to create theworkload.

http://www.dba-oracle.com/oracle10g_tuning/t_sql_access_advisor.htm

The SQL Tuning Advisor (STA) is primarily designed to replace the manual tuningof SQL statements and

speed up the overall SQL tuning process. The SQL Tuning Advisor studies poorly executing SQL statements

and evaluates resource consumption in terms of CPU, I/O, and temporary space.

The SQL Tuning Advisor (STA) works with the Automatic Tuning Optimizer (ATO) to analyze historical SQL

workload using data from the AWR, and it generates recommendations for new indexes and materialized views

that will reduce the disk I/O associated with troublesome SQL statements.

http://www.dba-oracle.com/oracle10g_tuning/t_sql_tuning_advisor.htm