如何查看oracle trace 文件

获得当前trace文件生成路径

SQL>select tracefile from v$process where addr in (select paddr from v$session where sid in (select sid from v$mystat))

2

开启当前session的trace

SQL>alter session set sql_trace=true

3

转换trc文件内容为可读的输出结果 (trace文件存放在F盘)

C:\Documents and Settings\Administrator>tkprof f:\oracle\administrator\diag\rdbm

s\orcl\orcl\trace\orcl_ora_1160.trc output=c:\aa.txt

4

转换的trc文件包含sql执行计划 (trace文件存放在D盘根目录)

C:\Documents and Settings\Administrator>tkprof d:\gdprd_ora_9120_htmlpkg.trc

output=d:\htmlpkg.txt explain=apps/apps@dev3 sys=no

tracen.（名词）A visible mark, such as a footprint, made or left by the passage of a person, an animal, or a thing.痕迹：因人、动物或物体通过造成或留下的一可见记号，如脚印Evidence or an indication of the former presence or existence of somethinga vestige.遗迹：表示某物以前出现过或存在的证据或指示；痕迹A barely perceivable indicationa touch:丝、毫：一种几乎不能感觉到的象征；一丝：spoke with a trace of sarcasm.带着一丝嘲讽地说An extremely small amount.极少量：非常小的数量A constituent, such as a chemical compound or element, present in quantities less than a standard limit.痕量：比标准限度数量小的一种组成物，如化学化合物或元素A path or trail that has been beaten out by the passage of animals or people.小路：由动物或人通过而踩出来的一条道路或小径A way or route followed.路线：跟随的道路或路线A line drawn by a recording instrument, such as a cardiograph.描记线：由一记录仪器，如心电图仪所画的线

---