Trace Files

From: Vincent Moynihan <vince_at_vmoy.demon.co.uk>
Date: Sat, 06 Jun 1998 11:28:45 +0100
Message-ID: <357919DC.2F88C8@vmoy.demon.co.uk>

Hi,

How can a session, with trace on, determine the file name of the Oracle trace file? The server runs on HP Unix 10-10.

We have tried using a stored procedure in a DBA account which returns

select 'ora_'||to_char(p.spid)||'.trc' "Trace File" from v$process p,v$session s
where p.addr=s.paddr
and s.username = pi_in_username;

However, this query returns all trace files for all the sessions that a user has open.

Any ideas? Received on Sat Jun 06 1998 - 05:28:45 CDT