SQL> alter session set tracefile_identifier='mysession'; 會話已更改。 SQL> Alter session set sql_trace= true; 會話已更改。 SQL> select * from SCOTT.DEPT; DEPTNO DNAME LOC ---------- ---------------------------- -------------------------- 50 ACCOUNTINGcs NEW YORK 60 RESEARCHcs DALLAS 70 SALEScs CHICAGO 80 OPERATIONScs BOSTON 51 ACCOUNTINGcscs NEW YORK 61 RESEARCHcscs DALLAS 71 SALEScscs CHICAGO 81 OPERATIONScscs BOSTON 11 ACCOUNTINGcs NEW YORK 21 RESEARCHcs DALLAS 31 SALEScs CHICAGO DEPTNO DNAME LOC ---------- ---------------------------- -------------------------- 41 OPERATIONScs BOSTON 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON 已選擇16行。 SQL> Alter session set sql_trace= false; 會話已更改。 SQL> select d.value||'\'||lower(rtrim(i.instance,chr(0)))||'_ora_'||p.spid||'.tr c' trace_file_name from(select p.spid from v$mystat m, v$session s,v$process p w here m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr ) p, (select t.inst ance from v$thread t,v$parameter v where v.name = 'thread' and(v.value = 0 or t. thread# = to_number(v.value))) i, (select value from v$parameter where name = 'u ser_dump_dest') d; TRACE_FILE_NAME -------------------------------------------------------------------------------- e:\app\yan\diag\rdbms\orcl\orcl\trace\orcl_ora_1584.trc 進(jìn)入命令行: C:\Users\yan>e: E:\>cd E:\app\yan\diag\rdbms\orcl\orcl\trace 由于剛才用了標(biāo)示符,所以跟蹤文件多了mysessio字符串: E:\app\yan\diag\rdbms\orcl\orcl\trace>tkprof orcl_ora_1584_mysession.trc orcl_or a_1584_mysession.txt TKPROF: Release 11.2.0.1.0 - Development on 星期三 3月 26 15:47:50 2014 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. |