Multiple choice technology databases

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
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The STATISTICS_LEVEL parameter controls statistics collection behavior. Setting it to BASIC disables AWR statistics collection and ADDM advisory services entirely. TYPICAL is the default setting and enables normal collection, while ALL enables additional statistics. OFF is not a valid value for this parameter - the question tests knowledge that BASIC disables these features.

Keep practicing — related questions