Re: alter session set sql_trace produces no file (or don't I find it?)

From: Marcel Kraupp <marcel.kraupp_at_gmx.ch>
Date: 15 Apr 2002 23:36:02 -0700
Message-ID: <332bb004.0204152236.21179326@posting.google.com>

Thanks a lot for bearing with me (this goes also to the other guy who answered me). I don't know if I was blind yesterday (or someone temporarly changed permissions on the directory) but today, everything is ok.

Also the hint of getting the spid is much appreciated.

Marcel

>
> The privileges on the directory may be wrong, so Oracle can't create a
> file.
> The file name is derived from the spid of the process.
> The spid can be determined by
>
> select spid
> from v$session s, v$process p
> where p.addr = s.paddr
> and s.audsid = userenv('sessionid')

>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Apr 16 2002 - 01:36:02 CDT