Unanswered: 'CPU used by this session' greater than 100% ?
I wanted to measure the CPU consumption of an Oracle 8.1.7 instance.
I collect the 'CPU used by this session' value from v$sysstat at T1 and T2, then I compute the percentage of CPU used by Oracle instance as follow:
%CPU = (Value at T2 - Value at T1) / (T2 - T1)
But this result is sometimes greater than 100 % !!
For Information: I only have one processor on the the server host, T2 - T1 = 10 seconds.
Am I wrong somewhere ?