Which of these initialization parameters is required for STATSPACK to collect statistics automatically with spauto.sql?
A. JOB_QUEUE_PROCESSES
B . JOB_QUEUE_INTERVAL
C . DB_JOB_QUEUE_PROCESSES
D . STATSPACK_JOB_AUTO
Explanation:
Answer A: The spauto.sql script performs automatic statistics gathering for Statspack. To run, it must use the DBMS_JOB package; for jobs to run, the JOB_QUEUE_PROCESSES value must be 1 or greater. Each of the other answers are invalid parameters.
No comments:
Post a Comment