ASM _asm_hbeatiowait与多路径的时间差问题。

 ASM _asm_hbeatiowait与多路径的时间差问题。

  这里对于“Waited 15 secs for write IO to PST”错误信息，根据文档1581684.1介绍，是在11.2.0.3.0之后出现的。同时在文档中有描述，如何手动修改这个检测超时的时间，可以通过参数_asm_hbeatiowait来控制：

alter system set "_asm_hbeatiowait"=<value> scope=spfile sid='*';

<需要重启ASM/CRS来时修改生效。>

为了确认，这个参数是在11.2.0.3之后出现的，我将全部数据库版本都查询一遍，具体可以参考下面信息：
======================10.2===================== 
SQL> select * from v$version; 
BANNER 
---------------------------------------------------------------- 
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod 
PL/SQL Release 10.2.0.5.0 - Production 
CORE 10.2.0.5.0 Production 
TNS for Linux: Version 10.2.0.5.0 - Production 
NLSRTL Version 10.2.0.5.0 - Production 
  
SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%undo%' order by ksppinm; 
hidden parameter value 
-------------------------------------------------------------------------------- ---------- 
_asm_acd_chunks 1 
_asm_allow_only_raw_disks TRUE 
_asm_allow_resilver_corruption FALSE 
_asm_ausize 1048576 
_asm_blksize 4096 
_asm_direct_con_expire_time 120 
_asm_disk_repair_time 14400 
_asm_droptimeout 60 
_asm_emulmax 10000 
_asm_emultimeout 0 
_asm_fob_tac_frequency 3 
hidden parameter value 
-------------------------------------------------------------------------------- ---------- 
_asm_instlock_quota 0 
_asm_kfdpevent 0 
_asm_libraries ufs 
_asm_maxio 1048576 
_asm_skip_resize_check FALSE 
_asm_stripesize 131072 
_asm_stripewidth 8 
_asm_wait_time 18 
_asmlib_test 0 
_asmsid asm 
21 rows selected. 
  
======================11.2.0.1===================== 
sqlplus / as sysdba 
Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 
SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm; 
hidden parameter value 
-------------------------------------------------------------------------------- 
_asm_hbeatwaitquantum 2 
  
======================11.2.0.2===================== 
 $ sqlplus / as sysdba 
Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production 
With the Partitioning, Oracle Label Security, OLAP, Data Mining 
and Real Application Testing options 
SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm; 
hidden parameter value 
-------------------------------------------------------------------------------- 
_asm_hbeatwaitquantum 2 
  
在11.2.0.3之后才有这个参数出现，也就是说ASM实例对磁盘超时的检测是在11.2.0.3之后才出现的 
======================10.2=====================

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod

PL/SQL Release 10.2.0.5.0 - Production

CORE 10.2.0.5.0 Production

TNS for Linux: Version 10.2.0.5.0 - Production

NLSRTL Version 10.2.0.5.0 - Production

 

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%undo%' order by ksppinm;

hidden parameter value

-------------------------------------------------------------------------------- ----------

_asm_acd_chunks 1

_asm_allow_only_raw_disks TRUE

_asm_allow_resilver_corruption FALSE

_asm_ausize 1048576

_asm_blksize 4096

_asm_direct_con_expire_time 120

_asm_disk_repair_time 14400

_asm_droptimeout 60

_asm_emulmax 10000

_asm_emultimeout 0

_asm_fob_tac_frequency 3

hidden parameter value

-------------------------------------------------------------------------------- ----------

_asm_instlock_quota 0

_asm_kfdpevent 0

_asm_libraries ufs

_asm_maxio 1048576

_asm_skip_resize_check FALSE

_asm_stripesize 131072

_asm_stripewidth 8

_asm_wait_time 18

_asmlib_test 0

_asmsid asm

21 rows selected.

 

======================11.2.0.1=====================

sqlplus / as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm;

hidden parameter value

--------------------------------------------------------------------------------

_asm_hbeatwaitquantum 2

 

======================11.2.0.2=====================

 $ sqlplus / as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining

and Real Application Testing options

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm;

hidden parameter value

--------------------------------------------------------------------------------

_asm_hbeatwaitquantum 2

 

在11.2.0.3.0之后才有这个参数出现，也就是说ASM实例对磁盘超时的检测是在11.2.0.3之后才出现的

======================11.2.0.3=====================

sys@R11203> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%undo%' order by ksppinm;

hidden parameter value

hidden parameter value

-------------------------------------------------- --------------------

_asm_hbeatiowait 15

_asm_hbeatwaitquantum 2

 

======================11.2.0.4=====================

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%undo%' order by ksppinm;

hidden parameter value

-------------------------------------------------------------------------------- ---------

_asm_hbeatiowait 15 <<<<<<<<<<<<<<<<<<<<

_asm_hbeatwaitquantum 2

 

 ======================12.1.0.1=====================

 $ sqlplus / as sysdba

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm;

hidden parameter value

--------------------------------------------------------------------------------

_asm_hbeatiowait 15

_asm_hbeatwaitquantum 2

 

在12.1.0.2之后，这个参数默认值被调整为120s

 ======================12.1.0.2=====================

 $ sqlplus / as sysdba

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select ksppinm as "hidden parameter", ksppstvl as "value" from x$ksppi join x$ksppcv using (indx) where ksppinm like '\_%' escape '\' and ksppinm like '%asm_hb%' order by ksppinm;

hidden parameter value

--------------------------------------------------------------------------------

_asm_hbeatiowait 120

_asm_hbeatwaitquantum 2