Dead connection detection (DCD) is a Oracle net feature which is primarily intended for environments where clients power down their systems or client machine crashes unexpectedly without gracefully closing the connections from the Oracle database. In cases where client machine abruptly crashes with properly disconnection the sessions from Oracle databases the resources locked by such…