Identify Trace file related to an oracle process -The Easy Way

To find the trace file location/name assosiated with a particular PID use the below query:

select PID,spid,username,program,background,tracefile from v$process;

tracefile column will give you the required location.

Share this post: on Twitter on Facebook on Google+