\"oracle基础讲义-诊断文件\

诊断文件 AlertSID.log： 记录Oracle内部信息，出现Oracle系统的错误信息。一般每天检查。background_dump_dest参数指定其位置。当数据库出现问题的时候首先检查alert日志文件。 SQL>show parameter _dump_dest可以查询 后台跟踪文件： 后台进程出现错误的时候做日志记录。目录同上 例如： Dump file d:\oracle\product\10gR2.0/admin/orcl/bdump\alert_orcl.log Fri Mar 13 17:12:36 2009 ORACLE V10gR2.0.1.0 - Production vsnsta=0 vsnsql=14 vsnxtr=3 Windows XP Version V5.1 Service Pack 2 CPU : 1 - type 586 Process Affinity : 0x00000000 Memory (Avail/Total): Ph:1328M/2038M, Ph+PgF:1512M/2135M, VA:1939M/2047M Fri Mar 13 17:12:36 2009 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Shared memory segment for instance monitoring created Picked latch-free SCN scheme 2 Using LOG_ARCHIVE_DEST_1 parameter default value as d:\oracle\product\10gR2.0\db_1\RDBMS Autotune of undo retention is turned on. IMODE=BR ILAT =18 LICENSE_MAX_USERS = 0 SYS auditing is disabled Fri Mar 13 17:12:48 2009 ksdpec: called for event 13740 prior to event group initialization Starting up ORACLE RDBMS Version: 10gR2.0.1.0. System parameters with non-default values: *