SQLnet Dead connection detection
Hi, all
I implemented the DCD base on the below metalink note
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
A discussion of Dead Connection Detection, Resource Limits, V$SESSION, V$PROCESS and OS processes [ID 601605.1]
Dead Connection Detection (DCD)
Implemented by
* adding SQLNET.EXPIRE_TIME = <MINUTES> to the sqlnet.ora file
With DCD 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.
If the client side connection is still connected and responsive, the client sends a response packet back to the database server,
resetting the timer..and another packet will be sent when next interval expires (assuming no other activity on the connection).
If the client fails to respond to the DCD probe packet
** the Server side process is marked as a dead connection and*
** PMON performs the clean up of the database processes / resources*
** The client OS processes are terminated*
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
but I found that there are still many idle connection (v$session) in my database server which are not cleaned up by PMON, is there anything I miss out?
Thanks