Oracle EBS SQL Trace日志收集的方法
Raw Trace的收集方法

1. 打开Trace，Help > Diagnostics > Trace > Trace > Trace with Binds and Waits

Trace项代表的意思

No Trace turns trace off.Regular Trace generates a regular SQL trace by performing the following statement:

ALTER SESSION SET SQL_TRACE = TRUE;

Trace with Binds writes bind variable values in the SQL trace fileTrace with Waits writes wait events in the SQL trace fileTrace with Binds and Waits writes both bind variable values and wait events in the SQL trace file

2.执行业务功能

3.关闭Trace，Help > Diagnostics > Trace > Trace > No Trace

系统会弹出一个窗口，告诉你Trace文件所在的目录。

这个目录实际上是数据库系统参数表(v$parameter)中的user_dump_dest的值，可以执行下边的SQL来找到Trace文件所在的目录

Tkprof: Release 9.2.0.1.0 - Production on Tue Dec 24 15:32:43 2002Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Trace file: ORCL102_ora_3064.trcSort options: default********************************************************************************count = number of times OCI procedure was executedcpu = cpu time in seconds executingelapsed = elapsed time in seconds executingdisk = number of physical reads of buffers from diskquery = number of buffers gotten for consistent readcurrent = number of buffers gotten in current mode (usually for update)rows = number of rows processed by the fetch or execute call********************************************************************************select *from employee where emp_id = 3737 call count cpu elapsed disk query current rows------- ------ -------- ---------- ---------- ---------- ---------- ----------Parse 10 0.00 0.03 0 0 0 0Execute 10 0.00 0.00 0 0 0 0Fetch 20 0.34 0.35 72 4730 0 10------- ------ -------- ---------- ---------- ---------- ---------- ----------total 40 0.34 0.39 72 4730 0 10 Misses in library cache during parse: 1Optimizer goal: CHOOSEParsing user id: 59 Rows Row Source Operation------- --------------------------------------------------- 1 TABLE ACCESS FULL EMPLOYEE

转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7677120