Re: Oracle 11 - 10053 trace doesn't produce any output
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 14 Mar 2008 14:13:50 GMT
Message-ID: <47da881e$0$1345$834e42db@reader.greatnowhere.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
Date: 14 Mar 2008 14:13:50 GMT
Message-ID: <47da881e$0$1345$834e42db@reader.greatnowhere.com>
On Fri, 14 Mar 2008 06:43:19 -0700, Steve Howard wrote:
> 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
Steve, I recently installed the whole bunch of patches fixing different things. I tried all that, even flushing trace file from oradebug. I believe that one of the ML patches has damaged handler for 10053. I will remove all the patches and install only CPU JAN 2008 when I have some time.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Fri Mar 14 2008 - 09:13:50 CDT