1. Instance Configuration1.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.
Instance configuration: 1. Configure the database record checkpoint in the alarm log, 2. Ensure that all user tracking files are stored in 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.
You may need to change the location of 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 items ----------- define background_core_dump string items string/u01/app/oracle/admin/PROD/bdu mpcore_dump_dest string/u01/app/oracle/admin/PROD/cdu mpmax_dump_file_size string items string partialuser_dump_dest string/U01/app/oracle/admin/PROD/udump -- all user trace files are stored here.