You work with a newly created database. Presently, there is no application load on the database
instance. You want to create a baseline for tuning the application, so you decide to collect
recommendations that can be implemented to improve application performance.
What action must you take to achieve this?
A.
Run Segment Advisor.
B.
Run the SQL Tuning Advisor (STA).
C.
Run the Automatic Workload Repository (AWR) report.
D.
Run the SQL Access Advisor with a hypothetical workload.
Hypothetical workload may generate a dimensional model based on workload. In the initial design of the system, this option is more useful