读懂trace file (tkprof格式化) 10

--- 等待事件汇总：

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1124900/