分析及格式化trace文件 - TKPROF (Transient Kernel Profiler)

发布时间:2020-08-10 17:51:52 作者:Davis_itpub
来源:ITPUB博客 阅读:204

TKPROF (Transient Kernel Profiler) :   TKPROF是一个用于分析oracle跟踪文件并且产生一个更加清晰合理的输出结果的可执行工具.   或者解释为Trace Kernel Profile 也是可以的。

先看例子:

tsgoooo</u01/product/admin/epd3/udump>$tkprof  epd3_ora_23315.trc  trace.txt   explain=sfis1/sfis1  print=50  record=sql.txt  

获得帮助: 输入tkprof 后直接回车可以看到帮助 

tsgoooo</u01/product/admin/epd3/udump>$tkprof
Usage: tkprof tracefile outputfile [explain= ] [table= ]
              [print= ] [insert= ] [sys= ] [sort= ]
  table=schema.tablename   Use 'schema.tablename' with 'explain=' option.
  explain=user/password    Connect to ORACLE and issue EXPLAIN PLAN.
  print=integer    List only the first 'integer' SQL statements.
  aggregate=yes|no
  insert=filename  List SQL statements and data inside INSERT statements.
  sys=no           TKPROF does not list SQL statements run as user SYS.
  record=filename  Record non-recursive statements found in the trace file.
  waits=yes|no     Record summary for any wait events found in the trace file.
  sort=option      Set of zero or more of the following sort options:
    prscnt  number of times parse was called
    prscpu  cpu time parsing
    prsela  elapsed time parsing
    prsdsk  number of disk reads during parse
    prsqry  number of buffers for consistent read during parse
    prscu   number of buffers for current read during parse
    prsmis  number of misses in library cache during parse
    execnt  number of execute was called
    execpu  cpu time spent executing
    exeela  elapsed time executing
    exedsk  number of disk reads during execute
    exeqry  number of buffers for consistent read during execute
    execu   number of buffers for current read during execute
    exerow  number of rows processed during execute
    exemis  number of library cache misses during execute
    fchcnt  number of times fetch was called
    fchcpu  cpu time spent fetching
    fchela  elapsed time fetching
    fchdsk  number of disk reads during fetch
    fchqry  number of buffers for consistent read during fetch
    fchcu   number of buffers for current read during fetch
    fchrow  number of rows fetched
    userid  userid of user that parsed the cursor 

几个重要参数的用法讲解

推荐阅读:
  1. Linux云计算架构师成长之路-第二章 Linux系统及特性-2.5 Linux系统组成
  2. S5PV210-kernel-从三星官方的内核开始移植

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

kernel profiler transient

上一篇:jquery validate验证

下一篇:Uncosted MMT with missing rows in WIP_PERIODS_BALANCES

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》