1Z0-043 · Question #128
In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these…
The correct answer is C. Automatic Workload Repository (AWR). See the full explanation below for the reasoning.
Question
In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics?
Options
- ARecovery catalog
- BOracle Enterprise Manager Repository
- CAutomatic Workload Repository (AWR)
- DOracle 10g Enterprise Manager Grid Control
- EAutomatic Database Diagnostic Monitor (ADDM)
How the community answered
(49 responses)- A4% (2)
- C86% (42)
- D8% (4)
- E2% (1)
Community Discussion
5
Orla P.Jun 26, 2026The correct answer is C, the Automatic Workload Repository. AWR is the component that collects, processes, and stores in-memory statistics at regular snapshots (by default every hour), and that snapshot data is exactly what Oracle uses for growth-trend analysis and capacity planning over time.
Ingrid P.Jun 28, 2026AWR snapshots are the foundation, but do not sleep on the retention period setting (default 8 days) because if you are building cards around long-term trend analysis, you need to know that ADDM reports and capacity projections only reach as far back as your retention window allows.
Bao N.Jun 22, 2026AWR is the right call here, but I have seen a ton of people burn time on D because they confuse the tool that displays the data with the thing that actually holds it. Grid Control reads from the repository, it does not store the snapshots itself. C is your answer, full stop.
Dervla O.Jun 26, 2026Almost circled B, then "regular intervals" locked it straight to AWR.
Ingrid P.Jun 26, 2026The wording says "in-memory statistics" which can trip you up because AWR snapshots are actually persisted to the SYSAUX tablespace, not held in memory, but the stats are collected from in-memory structures like the SGA and then stored by AWR, so C is correct. D is the tempting grab here because Grid Control sounds like the big management layer, but it consumes AWR data, it does not store it.