• 查询当前的Heartbeat值,需要以SYS用户登录

SQL> select cphbt from x$kcccp;

CPHBT
----------
727347134
0
0
0
0
0
0
0

8 rows selected.

  • ORACLE内部的心跳相关事件

SQL> select event#,name from v$event_name where name like'%heart%';

EVENT# NAME
---------- ----------------------------------------------------------------
75 heartbeat monitor sleep
380 ASM mount : wait for heartbeat
563 control file heartbeat