Re: How to set name of sql trace files?

From: <markp7832_at_my-deja.com>
Date: Mon, 10 Jan 2000 17:57:49 GMT
Message-ID: <85d6ik$f81$1@nnrp1.deja.com>

In article <85bhl9$94f$1_at_nnrp1.deja.com>, m_lowe_at_my-deja.com wrote:
> Hi,
>
> The default names for sql trace files is of the
> format ora_INSTANCE_unixpid.trc
>
> Does anyone know how to change this default and
> where sql_trace gets the instance SID from?
>
> Any suggestions much appreciated.
>
> Melissa
>

In ver 7 the only place to get the instance id was v$thread while in ver 8 you can find the instand id, SID, in v$instance as well.

I do not know of a way to change the default trace file name.

If you want to be able to locate a trace for a particular session the standard trick is to make your first sql statement a select of a constant from dual that you can grep on to locate your file. Something like select 'JOBNAME '||user from sys.dual would put the jobname concatenated to your Oracle userid into the trace file.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 10 2000 - 11:57:49 CST