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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14359/viewspace-719902/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14359/viewspace-719902/