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--所有用戶的跟蹤文件會放在此處。