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

On 15 Apr 2002 05:11:02 -0700, marcel.kraupp_at_gmx.ch (Marcel Kraupp) wrote:

>Hello
>
>
>I am on 8i and I want to create a trace file. I think they're supposed to be
>in the user dump dest directory:
>
>SQL> select value from v$parameter where name = 'user_dump_dest';
>
>VALUE
>-------------------------------------------------------------------
>/fs2/IMSMARE/dblg/user
>
>
>I cd to /fs2/IMSMARE/dblg/user and do a 'rm *' because I have no
>Idea which number my trace file is going to have.
>
>Further I go to SQL Plus I do an
>
>SQL> alter session set sql_trace=true;
>
>Session altered.
>
>Then I do a select statement, such as:
>
>SQL> select count(*) from all_objects;
>
> COUNT(*)
>----------
> 3720
>
>
>I believe to remember to do a second statement in order to close the
>cursor (but I might be wrong, anyway, it can't hurt):
>
>SQL> select 1 from dual;
>
> 1
>----------
> 1
>
>
>
>I cd iagain to the dump directory and find it empty. Empty is stays
>if I do an
>
>SQL> alter session set sql_trace=false;
>
>Session altered.
>
>
>What am I doing wrong?
>
>
>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')

All SYS session will return a 0 audsid.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 15 2002 - 11:53:41 CDT