default location of control trace file
RamApr 8 2009 — edited Apr 8 2009hi all
when i want to issue :
SQL>alter database backup controlfile to trace;
command execute without error
but when i open "D:\oracle\product\10.2.0\admin\orcl\udump"
there is no any file related to trace control file ,inside this directry .
when i issue :
select c.value || '/' || instance || '_ora_' ||
ltrim(to_char(a.spid,'fm99999')) || '.trc'
from v$process a, v$session b, v$parameter c, v$thread c
where a.addr = b.paddr
and b.audsid = userenv('sessionid')
and c.name = 'user_dump_dest'
;
output of above query is :
D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP/orcl_ora_2072.trc
but i dont find this file ..........