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

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

Does your oracle account have permissions to create a file in that directory ?

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."