509.Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)
A. A single SQL statement provided by a user
B. An existing SQL Tuning Set (STS)
C. A preprocessed Database Replay workload
D. A schema name
E. SQL statement identified in EM as using excessive resources
Answer: CD
下列哪项不能作为SQL调优顾问的输入?
C、数据库重放;
D、架构名
SQL优化指导可以对以下任一来源运行该指导:
活动SQL:分析当前活动的顶级SQL语句;
SQL优化集:分析用户提供的一组SQL语句;
以往的SQL(AWR):分析AWR快照捕获的SQL语句;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2124445/
,如需转载,请注明出处,否则将追究法律责任。