In oracle 10g, which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?
-
The analysis tool doesn’t provide output for the performance of SQL statement
-
The results of analysis are stored in tables, belonging to SYS user in the SYSAUX tablespace.
-
The results of analysis are stored in tables, belonging to SYS user in the SYSTEM tablespace.
-
The analysis runs automatically after each Automatic Workload Repository (AWR) snapshot.
ADDM (Automatic Database Diagnostic Monitor) runs automatically after each AWR snapshot is taken, analyzing the performance data between snapshots. The results are stored in the SYSAUX tablespace (not SYSTEM), in tables owned by the SYS user. ADDM provides comprehensive analysis including SQL statement performance recommendations.
ADDM (Automatic Database Diagnostic Monitor) in Oracle 10g runs automatically each time an AWR (Automatic Workload Repository) snapshot is taken (by default every 60 minutes), analyzing the period between the last two snapshots to identify performance bottlenecks. This is correct. ADDM does analyze SQL statement performance (it identifies high-load SQL), so the 'doesn't provide output for SQL' option is wrong. AWR/ADDM data is stored in the SYSAUX tablespace (introduced in 10g specifically to hold this kind of diagnostic data), not the SYSTEM tablespace, so both storage-location options are wrong.