RDBPROD: records fetched fragmented greater than records fetched
Hello everyone,
I noticed in the RMU SHO STAT record ststistics screen that "records fetched - fragmented" is greater
than actual "records fetched".
statistic......... rate.per.second............. total....... average......
name.............. max..... cur..... avg....... count....... per.trans....
record marked 19262 2 47.7 256197477 10.6
record fetched 418319 128 410.6 2204609730 91.3 <--------
fragmented 90845 3 594.3 3190786041 132.3 <-------
record stored 1084 0 1.2 6539401 0.2
fragmented 0 0 0.0 256 0.0
pages checked 17624 0 14.2 76638576 3.2
saved IO 3092 0 3.3 17835242 0.7
discarded 17623 0 13.0 70099189 2.9
record erased 346 0 0.4 2626983 0.1
fragmented 0 0 0.0 2967 0.0
temp record marked 19258 0 44.3 238230258 9.8
fetchd 291246 0 646.6 3471614375 143.8
stored 22275 0 67.5 362826440 15.1
erased 19258 0 44.2 237609029 9.8
sequential scan 40 0 0.4 2243700 0.0
record fetched 245584 0 734.1 3941376079 163.3
How to interpret it properly ?
Does it mean that ALL the records fetched are fragmented ??
Do increasing the page size will remedy this situation ?
Regards
Chris