nerdexam
Oracle

1Z0-083 · Question #36

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

The correct answer is B. Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY. C. A space usage management alert is automatically cleared after the underlying problem is E. Metrics are statistical counts for a specific unit. A - False. Tablespace Space Usage metris is database related B - True. Stateful alerts appear in DBA_OUTSTANDING_ALERTS and, when cleared, go to DBA_ALERT_HISTORY C - True. Most alerts (such as "Out of space") are clared automatically when the cause of the problem disappears. D…

Monitoring and Tuning

Question

Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)

Options

  • AAll metrics are instance related.
  • BCleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
  • CA space usage management alert is automatically cleared after the underlying problem is
  • DThey are generated by SMON when a tablespace is 97% full.
  • EMetrics are statistical counts for a specific unit.
  • FSTATISTICS_LEVEL must be set to ALL to generate alerts.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    81% (22)
  • D
    4% (1)
  • F
    11% (3)

Explanation

A - False. Tablespace Space Usage metris is database related B - True. Stateful alerts appear in DBA_OUTSTANDING_ALERTS and, when cleared, go to DBA_ALERT_HISTORY C - True. Most alerts (such as "Out of space") are clared automatically when the cause of the problem disappears. D - False. They're generated by MMON F - False. This parameter is not required to generate alerts

Topics

#server-generated alerts#metrics#DBA_ALERT_HISTORY#space usage alerts

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice