Shulou(Shulou.com)06/01 Report--

How to trace sql*net add the following parameter TRACE_LEVEL_CLIENT=16TRACE_DIRECTORY_CLIENT=/oracle/app/product/11.2.0/db/network/adminTRACE_FILE_CLIENT=clientTRACE_UNIQUE_CLIENT=ONTRACE_TIMESTAMP_CLIENT=ON to sqlnet.ora the resulting file is located at $ORACLE_BASE/diag/client/user_oracle/host_$NUMBER/trace use trcasst to analyze sql*net 's trace file [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] [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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.