Re: Database tracing

On 1/11/06, Sandeep Dubey wrote:
>
> Hi,
>
> Database 10.2, OS Linux
>
> I used to get the whole database tracing using Alter system set events
> '10046 trace name context forever', but now it doesn't seem to work.
>
> I am doing :
>
> SQL>Alter system set events '10046 trace name context forever';
>
> some sql queries
>
> SQL>Alter system set events '10046 trace name context off';
>
> I don't set any trace file in the user_dump_dest directory.
> Timed_statistics is TRUE.
>
> Am I missing something?
>
> Thanks
>
> Sandeep
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Sandeep,

That bug sounded familiar.
While reading the *README for 4751342 *for 10.1.0.2 on win32 I saw the following:

*10.2.0.1 Patch 2: 4751342

*

4517846 - SIMPLE SELECT AGAINST 10.2 CORE DUMPS IF EVENT 10046 SET  when searching the bug database for bug 4517846 a metalink search returned the following:

 *Bug No.* 4866996

 which is listed as platform-specific.
Not a direct hit, but close enough for horseshoes to indicate that other problems are likely on other ports.

Sounds like its time to open an iTAR.

hth.

Paul Received on Wed Jan 11 2006 - 20:24:25 CST