Re: Missing CPU time from 10046

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 3 Oct 2006 04:48:34 -0700
Message-ID: <1159876114.178045.54100@e3g2000cwe.googlegroups.com>

mccmx_at_hotmail.com wrote:
> It turns out that the reason the oracle.exe was consuming so much CPU
> which couldn't be accounted for in the 10046 trace was because someone
> had enabled a SQL Net level 16 trace in the sqlnet.ora file.
>
> The process that was slow issues millions of database calls, each of
> which was generating many lines of SQL Net trace data (creating a 2Gb
> file).
>
> Once this had been turned off the response time dropped dramatically.

Glad your problem has been found. In the old days, something that was creating such a huge trace file might have been found earlier ( by running out of space somewhere ).

These days it's easy to find a couple of gig here or a couple of gig there in most systems.

>
> Thanks for your help.

Thanks for the update after finding your solution.

Cheers John Received on Tue Oct 03 2006 - 06:48:34 CDT