10 lines
468 B
SQL
10 lines
468 B
SQL
select value ||'/'||(select lower(instance_name) from v$instance) ||'_ora_'||
|
|
(select spid from v$process where addr = (select paddr from v$session
|
|
where sid = (select sid from v$mystat
|
|
where rownum = 1
|
|
)
|
|
)
|
|
) || '.trc' tracefile
|
|
from v$parameter where name = 'user_dump_dest';
|
|
|