Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?()
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?()
Which three functions are performed by the SQL Tuning Advisor?()
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement,which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()
When tuning a network module what is the purpose of the grace period?()
You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?()
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?()
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)