Use SQL Tuning Advisor to obtain recommendations for improving performance of high-load SQL statements, and prevent regressions by only executing optimal plans.
SQL Tuning Advisor is SQL diagnostic software in the Oracle Database Tuning Pack. You can submit one or more SQL statements as input to the advisor and receive advice or recommendations for how to tune the statements, along with a rationale and expected benefit.
Tuning recommendations include:
-Collection of object statistics
-Creation of indexes
-Rewriting SQL statements
-Creation of SQL profiles
-Creation of SQL plan baselines
a is not correct this for sql access , c is correct Statistics Analysis: Checks each query object for missing or stale statistics, and
makes recommendations to gather relevant statistics.
upvoted 1 times
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Ray520
2 years, 6 months agonabhan2001nabhan
1 year agonabhan2001nabhan
1 year ago