To answer this question, you need to understand the components of Oracle architecture and their functions.
Option A) ADDM - This option is incorrect because ADDM (Automatic Database Diagnostic Monitor) is a component of Oracle that analyzes data and provides recommendations for improving database performance. It does not store statistics gathered by the MMON process.
Option B) AWR (Automatic Workload Repository) - This option is correct. AWR is a component of Oracle architecture that collects, processes, and stores performance-related data. It includes performance statistics gathered by various processes, including the MMON (Manageability Monitor) process. The statistics stored in AWR are used for performance tuning and analysis.
Option C) Data dictionary views - This option is incorrect. Data dictionary views provide information about the structure and content of the database, but they do not store statistics gathered by the MMON process.
Option D) Dynamic performance views - This option is incorrect. Dynamic performance views provide real-time information about the current state of the database, but they do not store statistics gathered by the MMON process.
The correct answer is B) AWR. This option is correct because AWR is specifically designed to store the statistics gathered by the MMON process and other performance-related data for analysis and tuning purposes.