Get the App
SLTechnology News&Howtos  ›  Database  › 

How to get to trace sql*net

Shulou Source: shulou.com Published: 2022-06-01 09:32:49 10月02日 Update

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

Tags: Files parameters analysis Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Xiaomi Docker Apple Huawei