We're getting some very odd results from statspack (8.1.7.3 on AIX 4.3.3) and I was wondering whether anyone else had seen anything similar. The report is over one month (which I work out has 2,678,400 secs in it). From the report our top wait event was db file sequential read with a total wait time of
516,236,745 secs and an average wait time of 7.7 secs!!
Am i interpretting the report wrong or is it giving totally screwy results as theres no way an average read is taking over 7 secs. - any thoughts appreciated
Top 5 Wait Events
~~~~~~~~~~~~~~~~~ Wait % Total
Event Waits Time (cs) Wt Time
---------------------------------------- ------------ ---------------- -------
db file sequential read 665,360,186 516,236,745,212 54.36
db file scattered read 616,315,771 348,700,968,413 36.72
latch free 25,164,217 42,256,814,866 4.45
log file sync 4,348,566 23,202,709,246 2.44
file open 2,483,483 7,702,849,954 .81
-------------------------------------------------------------
^LWait Events for DB: LIVE05 Instance: LIVE05 Snaps: 4602 -5349
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (cs) (ms) /txn
--------------------------- ---------- -------- --------------- ------- ------
db file sequential read ########## 0 ############### 7759 68.9
db file scattered read ########## 0 ############### 5658 63.8
latch free ########## ######## 42,256,814,866 16792 2.6
log file sync 4,348,566 1,258 23,202,709,246 53357 0.5
file open 2,483,483 0 7,702,849,954 31016 0.3
