SQL>
SQL>
SQL> select c.value || '\ORA' || to_char(a.spid,'fm00000') || '.trc'
2 from v$process a, v$session b, v$parameter c
3 where a.addr = b.paddr
4 and b.audsid = userenv('sessionid')
5 and c.name = 'user_dump_dest'
6 /
C.VALUE||'\ORA'||TO_CHAR(A.SPID,'FM00000')||'.TRC'
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP\ORA00604.trc