9.6. Answers to Review Questions

  1. B. The MMON process gathers statistics from the SGA and stores them in the AWR. The ADDM process then uses these statistics to compare the current state of the database with baseline and historical performance metrics before summarizing the results on the EM Database Control screens.

  2. D. Setting STATISTICS_LEVEL = BASIC disables the collection and analysis of AWR statistics. TYPICAL is the default setting, and ALL gathers information for the execution plan and operating system timing. OFF is not a valid value for this parameter.

  3. B. The I/O caused by user activity is the primary source of user waits because it is listed first in the graph's legend. Clicking the User I/O link opens a screen in which you can examine ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial