oracle – 如何使用TKPROF实用程序以及语法和参数？

概述如何使用TKPROF实用程序以及语法和参数？ 如果您只是在OS命令提示符下键入“tkprof”,它会列出其参数及其含义,如下所示： > tkprofUsage: tkprof tracefile outputfile [explain= ] [table= ] [print= ] [insert= ] [sys= ] [sort= ] table=schema.t 如何使用TKPROF实用程序以及语法和参数？解决方法 如果您只是在OS命令提示符下键入“tkprof”,它会列出其参数及其含义,如下所示：

> tkprofUsage: 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

典型用法是：

tkprof tracefile.trc myoutputfile.txt explain=myschema/password sys=no sort=exeela

有关详细信息,请参阅Performance Tuning Guide.

总结

以上是内存溢出为你收集整理的oracle – 如何使用TKPROF实用程序以及语法和参数？全部内容，希望文章能够帮你解决oracle – 如何使用TKPROF实用程序以及语法和参数？所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。