我想看看所谓的“心跳”，我操作步骤和下文中的一样： [php] 1.首先在系统级启用10046时间跟踪 并重新启动数据库使之生效 [oracle@jumper oracle]$ sqlplus "/ as sysdba" SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 19 09:24:04 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production SQL> alter system set event='10046 trace name context forever,level 12' scope=spfile; System altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 114365800 bytes Fixed Size 451944 bytes Variable Size 50331648 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production 检查CKPT进程的跟踪文件 我们可以很容易的发现CKPT进程每3秒都对控制文件进行一次写入 [oracle@jumper bdump]$ tail -f conner_ckpt_2563.trc WAIT #0: nam='rdbms ipc message' ela= 2994710 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2442 p1=3 p2=3 p3=3 WAIT #0: nam='rdbms ipc message' ela= 2995171 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2586 p1=3 p2=3 p3=3 WAIT #0: nam='rdbms ipc message' ela= 2994962 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2582 p1=3 p2=3 p3=3 WAIT #0: nam='rdbms ipc message' ela= 2995020 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2455 p1=3 p2=3 p3=3 WAIT #0: nam='rdbms ipc message' ela= 2995188 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2412 p1=3 p2=3 p3=3 WAIT #0: nam='rdbms ipc message' ela= 2995187 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2463 p1=3 p2=3 p3=3 WAIT #0: nam='rdbms ipc message' ela= 2995095 p1=300 p2=0 p3=0 WAIT #0: nam='control file parallel write' ela= 2448 p1=3 p2=3 p3=3 [/php] 问题是： 我的跟踪文件中怎么没有找不到类似如下的控制文件写事件呢： WAIT #0: nam='control file parallel write' ela= 2582 p1=3 p2=3 p3=3 我的操作系统是WinXP，Oracle是9iR2 9.2.0.1.0