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 hit rate with the following formula, and make changes to the definitions so that the hit rate becomes greater than 80%:

View analysis information buffer hit 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.