Eliminating Orphaned Oracle Sessions with SQLNET.EXPIRE_TIME
SQLNET.EXPIRE_TIME enables server-side dead connection detection (DCD) by sending periodic probes to verify cliant/server connections are still alive. When the server cannot reach the client, it raises an error on the connection and the server process exits, allowing PMON to reclaim database resourc...