🎴 Flashcard Mode
Oracle Database Administration and Performance Tuning
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which of the following options for the PFILE/SPFILE parameter STATISTICS_LEVEL turns off AWR statistics gathering and ADDM advisory services?
AnswerClick to flip back
A
BASIC
💡 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.