1. Instance Configuration1.1 Configure your database to record checkpoints in the alert.log file.1.2 Ensure all user trace files areoracle账号 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 partialbackground_dump_dest string /u01/app/oracle/admin/PROD/bdumpcore_dump_dest string /u01/app/oracle/admin/PROD/cdumpmax_dump_file_size string UNLIMITEDshadow_core_dump string partialuser_dump_dest string /u01/app/oracle/admin/PROD/udump–所有用户的跟踪文件会放在此处。