[Terry Notes] Oracle session tracking (2): TKPROF

 

Run tkprof in the system to convert the trace file into a format that can be read by humans.

(I personally don't feel very good. I don't need to get a good format when the trace file is output)
Syntax:Tkprof tracefile output_file

explain=username/passwd sys=yes| waits=yes| aggregate=yes| record=filename =number insert=filename =parameters 

Example:

tkprof ora11g_ora_11111.trc scott.txt explainscotttiger sysno waitsyes sortfchela

  Tkprof output (in the upper and lower parts ):.. -Development on Sat Aug:, Oracle and/or its affiliates. all rights reserved.: ora11g_ora_5829. options: **************************************** **************************************** = number of = cpu = elapsed = number of buffers gotten consistent = number of buffers gotten in current mode (usually = *************** **************************************** *************************: 9kcpyjv574vjc Plan Hash: * from t1 where owner = ----------------------------------------------------------------------------------------------------------------------------------------------:::: ---------- optimize table access full T1 (cr = pr = pw = us cost = size = card = ------- ------------------------------------------------- statement mode: table access (FULL) OF (TABLE)View Code :. options: session in tracefile. user SQL statements in trace file. internal SQL statements in trace file. SQL statements in trace file. unique SQL statements in trace file. SQL statements EXPLAINed using schema :. prof... lines in trace file. elapsed seconds in trace file.View Code: query and currentquery are the number of items retrieved by the select statement in the memory. current is the number of items modified by the update and delete statements in the memory: A good case is to get more rows with a small fatch. The parse of query refers to the number of data blocks obtained from the data dictionary (dictionary cache. Resource consumption is measured by the CPU column and elapsed column. To eliminate full table scans.