JNB
rss

skin by 이글루스

오라클

trace파일 확인 13.11.22 11:20
Select R.Value || '\' || Lower(T.Instance_Name) || '_ora_'
  || Ltrim(To_Char(P.Spid)) || '.trc' Trace_File
From V$process P, V$session S, V$parameter R, V$instance T
Where P.Addr = S.Paddr
And R.Name = 'user_dump_dest'
and s.sid = (select sid from v$mystat where rownum = 1);

        

    
Copyright 1999-2018 Zeroboard / skin by JY