Missing CPU time from 10046

From: <mccmx_at_hotmail.com>
Date: 29 Sep 2006 07:16:02 -0700
Message-ID: <1159539362.590958.55150@k70g2000cwa.googlegroups.com>

Oracle 10.2.0.2 W2K3 SE

When tracing a batch process (sqr.exe) using 10046 level 8, the trace file breaks down as follows:

80% SQL Net Message From Client (i.e. waiting for sqr.exe to execute) 15% DB CPU Time
5% DB I/O Read Time

However when I monitor this process at the OS level, the oracle.exe eats 100% of a single CPU while the batch process (sqr.exe) hovers around 3 or 4% for the duration of the job.

So my question is, what operations does oracle.exe perform that aren't accounted for in the 10046 trace file (or v$sesstat)...?

e.g. character set conversion etc..

The DB cpu figures are not matching the OS CPU figures....!

Any one have any idea why..?

Matt Received on Fri Sep 29 2006 - 09:16:02 CDT