Oracle Database Discussions

I came across one cool trick mentioned by Tanel Poder, but it doesn't seem to work for me. Could anyone please help in reading trace file on the fly.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options


SQL> !uname -a
Linux abc 2.6.16.60-0.34-smp #1 SMP Fri Jan 16 14:59:01 UTC 2009 x86_64 x86_64 x86_64 GNU/Linux

SQL> select value ||'/'||(select instance_name from v$instance) ||'_ora_'||
  2             (select spid||case when traceid is not null then '_'||traceid else null end
                 from v$process where addr = (select paddr from v$session
  3    4                                               where sid = (select sid from v$mystat
  5                                                          where rownum = 1
  6                                                     )
  7                                          )
  8             ) || '.trc' tracefile
  9      from v$parameter where name = 'user_dump_dest'
 10     /

TRACEFILE
--------------------------------------------------------------------------------
/n01/oraadmin1/diag/rdbms/abc/inst1/trace/inst11_ora_28754.trc

SQL> host mknod /n01/oraadmin1/diag/rdbms/abc/inst1/trace/inst11_ora_28754.trc p

SQL> set define off
SQL> host grep "WAIT" /n01/oraadmin1/diag/rdbms/abc/inst1/trace/inst11_ora_28754.trc &

SQL> set define on
SQL> alter session set events '10046 trace name context forever, level 8';

Session altered.

SQL> select * from dual;

D
-
X

SQL>
SQL> select * from dual;

D
-
X

{code}

I dont get any WAIT printed into the pipe file created before tracing.

Am i doing something wrong here ?

Edited by: Yasu on Nov 12, 2012 10:14 AM