您好,登錄后才能下訂單哦!
怎樣去 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] <filename> [options] default values are -odt -e0 -s <filename> 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_id>] Connection information [a] List all connections in a trace file [i <connection_id>] Decode a specified connection
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。