Thanks CL & Glenns, from settings properties...please find the settings of App, anything
not in order please point out.
Data retrieval Buffers
Buffer size - 20
Sort Buffer size - 20
number of existing blocks - 31445332
block size - 186368
potential number of blocks - 1050929147520
existing level 0 blocks - 5681250
existing upper level blocks - 25764082
average cluster ratio = 0.37
cache sizes
index cache settings - 102400
index cache current value - 102400
data file cache current setting - 3276800
data file cachel current value - 0
data file cache setting 307200
data file cache current value - 307034
|