程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> OCM_Session6_1_??????InstanceConfiguration

OCM_Session6_1_??????InstanceConfiguration

編輯:Oracle教程

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

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved