重庆分公司,新征程启航
为企业提供网站建设、域名注册、服务器等服务
怎样去 trace sql*net 在sqlnet.ora中添加如下参数 TRACE_LEVEL_CLIENT=16 TRACE_DIRECTORY_CLIENT=/oracle/app/product/11.2.0/db/network/admin TRACE_FILE_CLIENT=client TRACE_UNIQUE_CLIENT=ON TRACE_TIMESTAMP_CLIENT=ON 产生的文件位于 $ORACLE_BASE/diag/client/user_oracle/host_$NUMBER/trace 使用trcasst 分析sql*net的trace文件 [oracle@11g trace]$ trcasst -h Trace Assistant Utility: Version 11.2.0.3.0 Production on March 2, 2019 12:11:11 AM Copyright (c) 2001, 2011, Oracle. All rights reserved. TNS-04301: Trace Assistant Usage error: Invalid options. Usage : trcasst [options][options] default values are -odt -e0 -s always last argument -o[c|d][u|t][q] Net Services and TTC information [c] Summary of Net Services information [d] Detailed Net Services information [u] Summary of TTC information [t] Detailed TTC information [q] SQL commands (used together with u) -s Statistics -e[0|1|2] Error information, default is 0 [0] Translate NS error numbers [1] Error translation [2] Error numbers without translation -l[a|i ] Connection information [a] List all connections in a trace file [i ] Decode a specified connection