Setting up Oracle Network Tracing on the Client and Server in 11g

客户端:
修改$ORACLE_HOME/network/admin/sqlnet.ora

TRACE_LEVEL_CLIENT=16
TRACE_UNIQUE_CLIENT=ON
TRACE_DIRECTORY_CLIENT=/tmp/net_client_trace
DIAG_ADR_ENABLED=OFF


服务端(不需要重启listener):
修改$ORACLE_HOME/network/admin/sqlnet.ora
TRACE_LEVEL_SERVER = 16
TRACE_FILE_SERVER = SERVER
TRACE_DIRECTORY_SERVER=/tmp/net_server_trace
DIAG_ADR_ENABLED=OFF

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

转载于:http://blog.itpub.net/37279/viewspace-2126111/