Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
If the connection breaks and timeouts occurs due to network problems and you cannot convince your network team, you can monitor events between client and listener for detailed review.
For this :
Add the following to the sqlnet.ora file on the client side.
1 2 3 4 5 | TRACE_LEVEL_CLIENT=16 TRACE_FILE_CLIENT=CLIENT TRACE_DIRECTORY_CLIENT=<where the trace files are written> TRACE_TIMESTAMP_CLIENT=on TRACE_UNIQUE_CLIENT=on |
Add the following to the sqlnet.ora file on the server side.
1 2 3 4 | TRACE_LEVEL_SERVER=16 TRACE_FILE_SERVER=SERVER TRACE_DIRECTORY_SERVER=<where the trace files are written> TRACE_TIMESTAMP_SERVER=on |
When you restart listener, you will be able to see in detail what is happening in the listener trace.
