Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)
Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)
The SQL Tuning Advisor uses the following three sources: the Automatic Workload Repository (AWR), the Automatic Database Diagnostic Monitor (ADDM), and the shared SQL area. The AWR captures and stores performance data to be used for database tuning. The ADDM analyzes the data collected in the AWR to identify potential performance issues. The shared SQL area contains the memory structure where Oracle caches the SQL execution plans and statistics, providing valuable information for SQL tuning.
BCD: https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL543
ACD I think https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL542
sorry,BCD
Agree B C D