You have just created a database using scripts that you wrote. Now you notice that the automatic collection of database statistics by the EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_ PROCS procedure is not running. What might be the cause?

  1. The PFILE/SPFILE parameter GATHER_STATS=FALSE.

  2. Only databases created using Database Configuration Assistant have automatic statistics

  3. The SYSMAN user who owns the AWR is not logged in.

  4. The operating system does not support automatic statistics collection.


Correct Option: B

Find more quizzes: