You find that the execution time of reports in your datawarehouse application is significantly
high. You suspect the lack of indexes to be the reason for the degradation in performance.
Which advisory component would you refer to, in order to determine the appropriate
indexes?
A.
Memory Advisor
B.
Segment Advisor
C.
SQL Access Advisor
D.
Automatic Workload Repository (AWR)
E.
Automatic Database Diagnostic Monitor (ADDM)