Trace the connections being made to the Oracle database-客戶端跟蹤連線

At times, when troubleshooting connectivity issues or performance issues, you might need to run listener trace (server side) and/or a sqlnet trace (client side trace).  Oracle support staff will also ask for these files when you enlist their help in troubleshooting these issues.  Here are the steps on how you can do that:

1，To enable sqlnet trace (client side trace):啟用sqlnet跟蹤(客戶端跟蹤)

Add the following to the sqlnet.ora file on the application server(s) from where the connections are being made to the Oracle database:

Trace_level_client=16
Trace_directory_client= # use the full path to the trace directory
Trace_unique_client=on
Trace_timestamp_client=on

2，To stop the sqlnet trace:禁用sqlnet跟蹤(客戶端跟蹤)

Remove the following entries from sqlnet.ora or comment them out by using the # sign:

Trace_level_client=16
Trace_directory_client= # use the full path to the trace directory
Trace_unique_client=on
Trace_timestamp_client=on

You can run both trace (伺服器端、客戶端)at the same time for 15 minutes or so in order to get some meaningful data set.