Re: Oracle 11 - 10053 trace doesn't produce any output

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 14 Mar 2008 06:43:19 -0700 (PDT)
Message-ID: <a5f0480c-355c-4aae-8ef4-b8a27fe5c3a7@n77g2000hse.googlegroups.com>


On Mar 14, 4:10 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> Did anybody else try that? I did the following and got no trace file:
>
> SQL> alter session set events='10053 trace name context forever, level 1';
>
> Session altered.
> --
> Mladen Gogalahttp://mgogala.freehostia.com

No clue, I just tested it on 11.1.0.6 XP Pro and found it. Sorry, I have to ask :) - are you sure you are looking in the right location?

select value from v$diag_info where name = 'Default Trace File';

Regards,

Steve Received on Fri Mar 14 2008 - 08:43:19 CDT

Original text of this message