Subject: CPU Time calculation in AWR Reports 2007-11-01 - By Luis Fernando Cerri
Back
Hello, list.
At Statspack age, 'CPU Time' value in section 'Top 5 Timed Events' was
calculated as the difference of 'CPU used by this session' values
between two snapshots:
select 'CPU' , (e.value-b.value)/100 time
from stats$sysstat b, stats$sysstat e
where e.snap_id = :v_eid
and b.snap_id = :v_bid
and e.name = 'CPU used by this session'
and b.name = 'CPU used by this session';
Applying the same theory against DBA_HIST_SYSSTAT table (10gR2), I
can't get the same results of CPU Time in AWR reports:
select 'CPU' , (e.value-b.value)/100 time
from dba_hist_sysstat b, dba_hist_sysstat e
where e.snap_id = :v_eid
and b.snap_id = :v_bid
and e.stat_name = 'CPU used by this session'
and b.stat_name = 'CPU used by this session';
|
|
