ITPub博客

首页 > 数据库 > Oracle > 读懂trace file (tkprof格式化) 10

读懂trace file (tkprof格式化) 10

原创 Oracle 作者:tolywang 时间:2014-03-19 14:26:45 0 删除 编辑

--- 等待事件汇总:

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file sequential read                       126        0.05          0.64
  direct path read                             1963        0.38         84.85
  direct path write temp                          2        0.00          0.00
  direct path read temp                         236        0.03          0.95
  asynch descriptor resize                        4        0.00          0.00

  310  user  SQL statements in session.
   92  internal SQL statements in session.
  402  SQL statements in session.
    0  statements EXPLAINed in this session.
************************************************************
Trace file: GERPC_ora_63701322_delete_1t_001.trc
Trace file compatibility: 11.1.0.7
Sort options: prsela  exeela  fchela 
       1  session in tracefile.        ---  会话数量 
     310  user  SQL statements in trace file.   ---  SQL语句数量 
      92  internal SQL statements in trace file.  --- 内部SQL数量
     402  SQL statements in trace file.           --- 总SQL数量
     202  unique SQL statements in trace file.    --- 唯一SQL数量
    6046  lines in trace file.
     385  elapsed seconds in trace file.          --- 花费总时间

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-1124900/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13470443