This section explains tuning of the buffer length for view analysis information (pd_view_def_cache_size operand value).
- Information to be referenced
- See the following system activity statistical information provided by the statistics analysis utility:
- View analysis information buffer hits count (#OF VIEW CACHE HIT)
- Number of view analysis information acquisition requests (#OF VIEW DEF GET REQ)
- Tuning procedure
- Obtain the view analysis information buffer hits rate with the following formula, and make changes to the definitions so that the hits rate becomes greater than 80%:
- View analysis information buffer hits rate (%) =
- (view analysis information buffer hits count
number of view analysis information acquisition requests)
100
- Actions to be taken
- Increase the value of the pd_view_def_cache_size operand.