單項選擇題

What happens when you run the SQL Tuning Advisor with limited scope？（）

A. Access path analysis is not performed for SQL statements.
B. SQL structure analysis is not performed for SQL statements.
C. SQL Profile recommendations are not generated for SQL statements.
D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

你可能感興趣的試題

單項選擇題

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration？（）

A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.

單項選擇題

You have a very large table that your users access frequently.
Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）

A. The Automatic Memory Manager （AMM）
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor

What happens when you run the SQL Tuning Advisor with limited scope？（）

你可能感興趣的試題

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration？（）

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）

What happens when you run the SQL Tuning Advisor with limited scope？（）

You have a very large table that your users access frequently.
Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）