Find the trace file path for oracle CP

select
  u_dump.value 
  “Trace File Path”
from
             v$parameter u_dump
  cross join v$parameter db_name
  cross join v$process
        join v$session
          on v$process.addr = v$session.paddr
where
 u_dump.name   = ‘user_dump_dest’ and
 db_name.name  = ‘db_name’        AND
 sid= <sid>;

sid is the session id