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.5. Review Questions

  1. Which of the following components of Oracle architecture stores the statistics gathered by the MMON process?

    1. ADDM

    2. AWR

    3. Data dictionary views

    4. Dynamic performance views

  2. Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?

    1. OFF

    2. TYPICAL

    3. ALL

    4. BASIC

  3. The following graphic is from the Sessions: Waiting And Working section of the EM Database Control Performance screen. Using this output, which of the following is the primary source of user wait activity?

    1. CPU Used

    2. User I/O

    3. System I/O

    4. Configuration

  4. The following graphic shows the SQL statements that are having ...

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