ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-51

043-51

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-06 10:10:51 0 删除 编辑
51. You want to use the SQL Tuning Advisor to generate recommendation
s for badly written SQL statements in your development environment. W
hich three sources can you select for the advisor to analyze? (Choose
three.)
A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs
Answer: A,B,C
You can use the SQL Tuning Advisor to analyze SQL statements and obtain performance
recommendations. Typically, you run this advisor as an ADDM performance-finding action.
Additionally, you can run the SQL Tuning Advisor when you want to analyze the top SQL
statements consuming the most CPU time, I/O, and memory.

Sources for SQL Tuning Advisor to analyze:
– Top SQL: Analyzes the top SQL statements
currently active
– SQL Tuning Sets: Analyzes a set of SQL statements
you provide
– Snapshots: Analyzes a snapshot
– Baselines: Analyzes a baseline

Baselines are used to retain snapshot data. Therefore, snapshots belonging to baselines are
retained until the baselines are dropped.
Usually, you set up baselines from some representative periods in the past, to be used for
comparisons with current system behavior. You can also set up threshold-based alerts by using
baselines from Database Control.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717807/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 043-053
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    202934