I'm reviewing statspack snapshots on an 8.1.7 database and am seeing
something that looks totally wacked out. The time waited on one of my
system events jumped 1000x between two hourly snapshots. Anyone else
ever seen something like this? I'm highly suspicous that something got
corrupted in the v$system_event view. Look at the jump in time waited
between snapshots 6170 and 6171 for this event. Are there any know bugs
that would cause this? TIA.
SELECT
s.snap_id
, s.snap_time
, e.event
, e.total_waits
, e.time_waited
FROM stats$system_event e, stats$snapshot s
WHERE s.snap_id IN (6160,6170,6171,6172)
AND s.snap_id = e.snap_id
AND e.event = 'db file scattered read'
/
SNAP_ID SNAP_TIME EVENT TOTAL_WAITS TIME_WAITED
------- --------------- ------------------------ ----------- -----------
6160 01-Apr-03 15:00 db file scattered read 3392264 1183083
6170 01-Apr-03 16:00 db file scattered read 3423393 1193985
6171 01-Apr-03 17:00 db file scattered read 3792096 1845246031
6172 01-Apr-03 18:00 db file scattered read 3792968 1845246570
Received on Thu Apr 17 2003 - 12:46:15 CDT
