绑定变量及其优缺点 - 数据库编程

SQL> SET LINESIZE 180
SQL> COLUMN trace_file FORMAT A100
SQL> SELECT s.sid, -->获得跟踪文件位置
2 s.serial#,
3 p.spid,
4 pa.value || '/' || LOWER(SYS_CONTEXT('userenv','instance_name')) ||
5 '_ora_' || p.spid || '.trc' AS trace_file
6 FROM v$session s,
7 v$process p,
8 v$parameter pa
9 WHERE pa.name = 'user_dump_dest'
10 AND s.paddr = p.addr

11 AND s.audsid = SYS_CONTEXT('USERENV', 'SESSIONID');

SID SERIAL# SPID TRACE_FILE
---------- ---------- ------------ --------------------------------------------------------------
1084 938 10883 /u02/database/CNMMBO/udump/cnmmbo_ora_10883.trc

SQL> SQL>
SQL> ho pwd
/users/oracle

-->使用tkprof工具格式化跟踪文件便于阅读
SQL> ho tkprof /u02/database/CNMMBO/udump/cnmmbo_ora_10883.trc /users/oracle/ins_t.txt explain=goex_admin/goex_admin

绑定变量及其优缺点(七)