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 05:11:02 -0700
Message-ID: <332bb004.0204150411.5bc3f6a5@posting.google.com>

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 Received on Mon Apr 15 2002 - 07:11:02 CDT