Re: Missing CPU time from 10046

> I still recommend getting and reading Cary Millsap's book. It will
> help you drive through this debugging exercise to deeper understanding
> of exactly what is happening in your environment.

I read the book cover to cover about a year ago. I had another read through certain 'heavy' chapters last night.

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.

Thanks for your help.

Matt Received on Tue Oct 03 2006 - 02:15:00 CDT