Tham khảo tài liệu 'oracle 8 database administration volume 1 instruction guide phần 4', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Trace Files and the ALERT File Controlling the Trace File USER_DUMP_DEST ALERT file BACKGROUND_DUMP_DEST 3-24 Copyright Oracle Corporation 1998. All rights reserved. ORACLE1 The following parameters control the location and size of the trace files BACKGROUND_DUMP_DEST defines the location of the background trace file and ALERT file. USER_DUMP_DEST defines where trace files will be created at the request of the users. MAX_DUMP_FILE_SIZE specified in O S blocks limits the size of user trace files. Note The MAX_DUMP_FILE_SIZE and USER_DUMP_DEST parameters are dynamic initialization parameters. On UNIX the alert file is named alert SID .log and is located in the ORACLE_HOME rdbms log directory by default. On Windows NT the alert file is named SID and is located in the ORACLE_HOME RDBMS80 TRACE directory by default. Oracle8 Database Administration 3-41 Lesson 3 Managing an Oracle Instance Guidelines Check the ALERT file periodically to Detect internal errors ORA-600 and block corruption errors Monitor database operations View the nondefault initialization parameter 3-25 Copyright Oracle Corporation 1998. All rights reserved. ORACLE It is important for the database administrator to check the ALERT file regularly to detect problems before they become serious. The following information is logged in the ALERT file All internal errors ORA-00600 and block corruption errors ORA-01578 Operations that affect database structures and parameters and Server Manager statements such as STARTUP SHuTdOWN archive LOG and RECOVER The values of all nondefault initialization parameters at the time the instance starts Instructor Note You may query the current setting for BACKGROUND_DUMP_DEST change to that directory and show the alert and trace files in the directory. 3-42 Oracle8 Database Administration Summary Summary Summary Starting up and shutting down an instance Understanding the use of dynamic performance views Describing the use of trace files 3-26 Copyright Oracle .
