配置TKPROF

--打开sql_trace

--level 的等级 

--1 启用标准sql_trace 工具（如同 sql_trace=true）

--4 启用sql_trace 并捕捉跟踪文件中的绑定变量值

--8 启用sql_trace 并捕捉跟踪文件的等待事件

--12 启用sql标准的sql_trace 并不卓绑定变量和等待事件

hr@ORCL> alter session set timed_statistics=true;

Session altered.

hr@ORCL> alter session set events '10046 trace name context forever,level 12';

Session altered.

hr@ORCL> SELECT COUNT(*) FROM t_big;
SELECT COUNT(*) FROM t_big
                     *
ERROR at line 1:
ORA-00942: table or view does not exist


hr@ORCL> SELECT COUNT(*) FROM tbig;

  COUNT(*)
----------
     72495

hr@ORCL> SELECT * FROM tbig
  2  WHERE owner='SYS'
  3  AND object_type='PACKAGE'
  4  AND object_name LIKE 'F%';

no rows selected
--获取跟踪文件的文件名
hr@ORCL> column trace new_val TRACE
hr@ORCL> 
hr@ORCL> select c.value || '/' || d.instance_name || '_ora_' || a.spid || '.trc' trace
  2    from v$process a, v$session b, v$parameter c, v$instance d
  3   where a.addr = b.paddr
  4     and b.audsid = userenv('sessionid')
  5     and c.name = 'user_dump_dest';

TRACE
----------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_29506.trc

创建tkprof 报告

[oracle@ocp ~]$ tkprof /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_29506.trc first.prf