OCM_Session6_1_??????InstanceConfiguration - 数据库编程

1. Instance Configuration 1.1 Configure your database to record checkpoints in the alert.log file. 1.2 Ensure all user trace files are placed in the USER_DUMP_DEST location.
实例配置：1.配置数据库记录检查点在告警日志日志中，2.确保所有用户的跟踪文件放在 USER_DUMP_DEST
1.1 Configure your database to record checkpoints in the alert.log file. LOG_CHECKPOINTS_TO_ALERT lets you log your checkpoints to the alert file. Doing so is useful for determining whether checkpoints are occurring at the desired frequency.
SQL> alter system set log_checkpoints_to_alert=true; System altered.

1.2 Ensure all user trace files are placed in the USER_DUMP_DEST location.
可能需要更改USER_DUMP_DEST位置 USER_DUMP_DEST specifies the pathname for a directory where the server will write debugging trace files on behalf of a user process. SQL> show parameter dump
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_core_dump string partial background_dump_dest string /u01/app/oracle/admin/PROD/bdu mp core_dump_dest string /u01/app/oracle/admin/PROD/cdu mp max_dump_file_size string UNLIMITED shadow_core_dump string partial user_dump_dest string /u01/app/oracle/admin/PROD/udump--所有用户的跟踪文件会放在此处。