SELECT d.value||'/'||lower(rTRIM(i.INSTANCE,chr(0))) ||'_ora_'||p.spid||'.trc' trace_file_name
FROM
(SELECT *
FROM SYS.v_$mystat m ,SYS.v_$session s ,SYS.v_$process p
WHERE m.STATISTIC#=1 AND s.SId=m.SID AND p.ADDR=s.PADDR) p,
(SELECT t.INSTANCE FROM SYS.v_$thread t ,SYS.v_$parameter v
WHERE v.NAME='thread' AND (v.VALUE=0 OR t.THREAD#=to_number(v.VALUE)))i,
(SELECT VALUE FROM SYS.v_$parameter WHERE NAME='user_dump_dest') d
－－
tkprof C:oracleproduct10.2.0adminZYFudumpzyf_ora_604.trc C:oracleproduct10.2.0adminZYFudumpsession.txt explain=test/test aggregate=yes sys=no waits=yes sort=fchela
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/780947/viewspace-902892/ ，如需转载，请注明出处，否则将追究法律责任。
