ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Trace the connections being made to the Oracle database-客户端跟踪连接

Trace the connections being made to the Oracle database-客户端跟踪连接

原创 Linux操作系统 作者:landf 时间:2012-03-30 10:13:49 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 定制SQL*Plus环境
请登录后发表评论 登录
全部评论

注册时间:2008-02-14

  • 博文量
    68
  • 访问量
    488132