Query to find the Tracefile using SID in Oracle Database

How to find the Tracefile using SID in Oracle?

Below mentioned query will help you find the Tracefile if you have enabled the SQL Trace in your Oracle Database. Make sure you know the SID for which you want to check the tracefile.

SELECT p.tracefile
FROM   v$session s
       JOIN v$process p ON s.paddr = p.addr
WHERE  s.sid = &SID;