How to know the trace file name?
"alter database backup controlfile to trace"
how to identifiy which is my controlfile trace from udump folder,
i am using the following query....
select 'ora_'||spid||'.trc' from v$process where addr in
(select paddr from v$session where sql_hash_value in
(select hash_value from v$sql where upper(sql_text) like 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE%'))
but this is not giving the correct file name in RAC environment (even if i use gv$ in all places of the above query instead of v$).
can any one help me out to findout the filename exactly in all cases....????