一、 使用
TKPROF
工具分析跟踪文件
实验目的：让学员熟练掌握 使用
TKPROF
进行 跟踪文件分析
实验环境： VmWare Server 1.0.4+RHEL as 4+Oracle 10g 10.2.0.1.0
实验场景：
Tkprof 是一个用于分析 Oracle 跟踪文件并且产生一个更加清晰合理的输出结果的可执行工具。如果一个
系统的执行效率比较低 ， 一个比较好的方法是通过跟踪用户的会话并且使用 Tkprof 工具使用排序功能格式
化输出，从而找出有问题的 SQL 语句。
TKPROF 工具是 oracle 提供的免费工具，有人习惯称之为 "Trace Kernel Profile", 也有人称之为 "Tool Kit
Profiler" 或 " transient kernel profiler. " 。不过，这都不重要，重要的是我们应该掌握究竟应该如何
使用该工具对 TRACE 文件进行分析。
TKPROF 工具使用简介：
[oracle@rhel10g ~]$ 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
评论1