SELECT c.value || ‘/‘ || d.instance_name || ‘_ora_‘ || a.spid || ‘.trc‘ trace
   FROM v$process a, v$session b, v$parameter c, v$instance d
  WHERE a.addr = b.paddr
    AND b.audsid = userenv(‘sessionid‘)
    AND c.name = ‘user_dump_dest‘;