Multiple choice technology databases

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

Only databases created using the Database Configuration Assistant (DBCA) automatically have the statistics collection job configured. When you create databases manually with scripts, the automatic statistics collection procedure is not set up by default. This is a documented behavior, not a parameter or login issue.

Keep practicing — related questions