nerdexam
Oracle

1Z0-083 · Question #82

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

The correct answer is A. ADDM can recommend shrinking the buffer cache. B. ADDM can recommend extending the buffer cache. E. By default, AWR snapshots are automatically purged after eight days. AWR Snapshot's default interval is 1 hour and retention is 8 days. It means All AWR statistics are collected every 1 hour and they are kept 8 days by default.

Monitoring and Tuning

Question

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

Options

  • AADDM can recommend shrinking the buffer cache.
  • BADDM can recommend extending the buffer cache.
  • CBy default, MMON creates an AWR snapshot every 30 minutes.
  • DADDM performs its analysis only when a DBA requests it.
  • EBy default, AWR snapshots are automatically purged after eight days.
  • FAWR snapshots must be deleted when no longer required by ADDM.

How the community answered

(25 responses)
  • A
    84% (21)
  • C
    4% (1)
  • D
    4% (1)
  • F
    8% (2)

Explanation

AWR Snapshot's default interval is 1 hour and retention is 8 days. It means All AWR statistics are collected every 1 hour and they are kept 8 days by default.

Topics

#AWR snapshots#ADDM recommendations#MMON#buffer cache

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice