Oracle Listener Tracing & network troubleshooting

This article focuses on the Oracle Listener Tracing & Troubleshooting, in this article we would explore the parameters available to enable tracing on Oracle listener so that additional data is available to troubleshoot network related issues between client & server. To enable Listener tracing add following parameters to listener.ora:- TRACE_LEVEL_LISTENER=[0-16|USER|ADMIN|SUPPORT|OFF]#This parameter defines the level of…

Dead Connection Detection

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…