Re: Times do not add up in 10046 trace file

> Without doing a lot of digging, have you explored this as an option:
> SELECT
> STAT_NAME,
> VALUE
> FROM
> V$OSSTAT
> WHERE
> STAT_NAME='NUM_CPUS';
>
> STAT_NAME VALUE
> NUM_CPUS 4
>

STAT_NAME
VALUE

> In this Oracle database, 1 second of elapsed time is equal to 4 seconds
> of potential CPU time. There are of course other possible causes.

Regardless of the amount of actual CPU time that elapsed, we still have over 100 seconds of wait time which isn't accounted for in the elapsed time.

Matt Received on Wed Oct 11 2006 - 07:32:11 CDT