本文共 1302 字,大约阅读时间需要 4 分钟。
怎样去 trace sql*net 在sqlnet.ora中添加如下参数TRACE_LEVEL_CLIENT=16TRACE_DIRECTORY_CLIENT=/oracle/app/product/11.2.0/db/network/adminTRACE_FILE_CLIENT=clientTRACE_UNIQUE_CLIENT=ONTRACE_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 AMCopyright (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
转载于:https://blog.51cto.com/10579005/2364145