trace files中的内容看不懂，谁能帮解释一下！

[ylg007]

Dump file E:\oracle\admin\allscm\udump\ORA02204.TRC
Sun Feb 01 20:57:41 2004
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: allscm

Redo thread mounted by this instance: 1

Oracle process number: 15

Windows thread id: 2204, image: ORACLE.EXE


*** SESSION ID:(17.61) 2004-02-01 20:57:41.625
APPNAME mod='PL/SQL Developer' mh=1190136663 act='SQL Window - New' ah=3399691616
=====================
PARSING IN CURSOR #1 len=33 dep=0 uid=0 oct=42 lid=0 tim=0 hv=3732290820 ad='42bc7ec'
alter session set sql_trace=true
END OF STMT
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=0

[leecooper0918]

用tkprof解析一下,你就能看懂了.

[ylg007]

本人初学,tkprof是何方神圣啊.

[welyngj]

From www.dba-village.com

This trace means that you are using 'PL/SQL Developper' in 'SQL Window - New' window and that you are enabling the trace (alter session sql_trace=true) which is the file you are posting here.

[oldmancsdn]

学习

[welyngj]

From www.dba-village.com
anthor dba's reply:
This trace file give you lots of information. e.g. it tells you that you used 0 cpu cycle for running 'alter session set sql_trace=true'. It was executed as cursor 1 with lenth 33, depth 0, time=0, elapsed time 0, rows returned 0 etc.

[ylg007]

ocp中有tkprof用法介绍吗?

[ylg007]

我已经找到了.
不过是英文的,真伤脑筋.
谢谢各位.