---sql_trace文件分为两类
会话级别：alter session set sql_trace=true;
实例级：alter database set sql_trace=true;
----测试生成trace文件

---查找trace文件

---查看生成的trace文件

---需要用tkprof工具格式化trace文件

---查看格式化后的trace文件

[oracle@zh trace]$ ls asdf.txt
asdf.txt
[oracle@zh trace]$ more asdf.txt
********************************************************************************
SQL ID: fa48b614fg9d1 Plan Hash: 128828553
select count(*)
from
hr.employees where job_id='SA_REP'
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.01 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 1 1 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.01 0.02 1 1 0 1
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ------------------------------------------------
---
1 1 1 SORT AGGREGATE (cr=1 pr=1 pw=0 time=6561 us)
30 30 30 INDEX RANGE SCAN EMP_JOB_IX (cr=1 pr=1 pw=0 tim
e=6531 us cost=1 size=270 card=30)(object id 88139)
********************************************************************************

ITPub博客

SQL_TRACE文件