GRID: Dead Connection Connection or DCD and RAC 11.2 (文档 ID 1136945.1)
--11gR2 rac中， dcd 要在 db_home中设置，而不是在GRID_HOME中设置
With DCD is enabled, the Server-side process sends a small 10-byte packet to the client process after the duration of the time interval specified in minutes by the SQLNET.EXPIRE_TIME parameter.
How to Check if Dead Connection Detection (DCD) is Enabled in 9i ,10g and 11g (文档 ID 395505.1)
How Dead Connection Detection is Triggered
Let us take an example. Suppose we set the sqlnet.expire_time = 2 and the timer got armed at 10.00 am,
then the DCD packets will be sent only if there is no network(I/O) activity for that connection in the next 2 min. i.e. till 10.02 am.
If there is an i/o in between 10 to 10.02 then the connection is not dead one as the activity took place on that particular connection, which means the connection is alive and hence the DCD packets will not be sent for this period of time.
So, at any point of time, the DCD packets will only be sent if there is no activity for the full span of specified time interval.
As the first connection operation itself considered a successul I/O, the first DCD probe packet would go only after 2 * expire_time and successive one's would be sent every expiry_time provided no activity in that next span too.
多数因晚间无业务时，使用dblink访问数据，长时间空闲后，连接时报错失去连接等，需要重新连接才能正常；为防止连接超时断开，可以通过设置job定时执行的方式解决，job内容可以简单设置为如下：select 1+1 from dual@dblink