千家信息网

怎样去 trace sql*net

发表于:2025-01-21 作者:千家信息网编辑
千家信息网最后更新 2025年01月21日,怎样去 trace sql*net 在sqlnet.ora中添加如下参数TRACE_LEVEL_CLIENT=16TRACE_DIRECTORY_CLIENT=/oracle/app/product/
千家信息网最后更新 2025年01月21日怎样去 trace sql*net
怎样去 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


0