Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: User trace files
This depends on O/S and most likely also on version.
For 8.1.5 on wintel, the files are located on in the directory pointed to by
the user_dump_dest parameter (you could check that in the v$parameter view)
and the file is named ora0<n>.trc, where is the system process id (spid) of
the background session.
You can obtain the spid by the following query:
select spid
from v$session s, v$process p
where p.addr = s.paddr
and s.audsid = userenv('sessionid')
(This is not going to work for SYS sessions, as those don't have an unique
audsid)
Hth,
Sybrand Bakker, Oracle DBA
"Julio Peixoto" <cjulioNOcjSPAM_at_originet.com.br.invalid> wrote in message
news:03014155.7a969653_at_usw-ex0103-018.remarq.com...
> Can anybody tell me how are user trace files named?
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Sat Jun 24 2000 - 00:00:00 CDT