Re: Need help locating correct trace file.

At Solaris 2.6 8.1.6 I use the following script reliably. You have to run this as SYS or internal. You get the trace file name by "select name from my_trace;":

create or replace view my_trace as

select	distinct p.spid


	, f.value || '/' || lower (i.instance_name) || '_ora_' || to_char (p.spid,

'fm999999') || '.trc' as name
from	v$process p


	, v$session s

	, v$instance i

	, v$parameter f

where	1 = 1
and	p.addr = s.paddr
and	s.audsid = userenv ('sessionid')
and	'user_dump_dest' = f.name

create public synonym my_trace for my_trace;

grant select on my_trace to public; Received on Sat Jan 20 2001 - 12:58:14 CST