21.5.2 Tuning the buffer length for view analysis information

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[Figure] number of view analysis information acquisition requests)[Figure] 100
Actions to be taken
Increase the value of the pd_view_def_cache_size operand.