Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC)

MOSC Banner

RDBPROD: records fetched fragmented greater than records fetched

edited Sep 18, 2014 7:43AM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 1 commentAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center