Oracle EBS SQL Trace日记收集的方法

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

查看更多 下一篇