Multiple choice technology performance

This tool in Oracle10g defaults to a collection interval every 30 minutes and collects data that is the foundation for all of the other self-tuning features. It is very much like STATSPACK, especially the level-5 STATSPACK collection mechanism where top SQL is collected every hour, based on your rolling thresholds for high-use SQL.

  1. Automatic Maintenance Tasks(AMT)

  2. Automatic Workload Repository(AWR)

  3. Automatic Database Diagnostic Monitor(ADDM)

  4. Automatic Storage Management(ASM)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Automatic Workload Repository (AWR) is the built-in repository in Oracle 10g and later that collects performance statistics at regular intervals (default 30 or 60 mins), replacing and expanding upon the functionality of STATSPACK.

Keep practicing — related questions