DCD (SQLNET.EXPIRE_TIME) - what it is and what it is not
Hello Database Networking Community
In response to postings in some discussions as well as multiple service requests with Oracle Software Support heading off the wrong direction, I believe it is vitally important to emphasize WHAT DCD is used for and WHAT it is not (as well as mention a potential and useful "side effect" of DCD
What it is not
Firstly, many Oracle users assume that the DCD setting of "SQLNET.EXPIRE_TIME" in the sqlnet.ora file is used when you want to specifically TERMINATE* a client session on the Database side after a period of time. The assumption is that if DCD is set to, say, 10 (in minutes) then a client connection remaining IDLE for a period exceeding this setting will be DISCONNECTED.
In response to postings in some discussions as well as multiple service requests with Oracle Software Support heading off the wrong direction, I believe it is vitally important to emphasize WHAT DCD is used for and WHAT it is not (as well as mention a potential and useful "side effect" of DCD
What it is not
Firstly, many Oracle users assume that the DCD setting of "SQLNET.EXPIRE_TIME" in the sqlnet.ora file is used when you want to specifically TERMINATE* a client session on the Database side after a period of time. The assumption is that if DCD is set to, say, 10 (in minutes) then a client connection remaining IDLE for a period exceeding this setting will be DISCONNECTED.
5