O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required