Nonstop Database, HiRDB Version 9 System Operation Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
(1) Tuning method (1)
- Information to be referenced
- See the following system activity statistical information provided by the statistics analysis utility:
- Tuning procedure
- Obtain the routine definition cache hit rate with the following formula, and tune it so that the hit rate becomes 100%:
- Routine definition cache hit rate (%) =
- (routine definition cache hits count
number of routine definition information acquisition requests)
100
- Actions to be taken
- Increase the value of the pd_routine_def_cache_size operand.
(2) Tuning method (2)
- Information to be referenced
- See the following system activity statistical information provided by the statistics analysis utility:
- Tuning procedure
- Obtain the routine definition cache utilization factor with the following formula, and tune it so that the utilization factor becomes 90% or higher:
- Routine definition cache utilization factor (%) =
- (maximum value of total routine definitions cache size
allocated routine definition cache size)
100
- Actions to be taken
- Reduce the value of the pd_routine_def_cache_size operand.
(3) Tuning method (3)
- Information to be referenced
- See the following system activity statistical information provided by the statistics analysis utility:
- Plug-in routine definition cache hits count (# OF PLG-RTN CACHE HIT)
- Number of plug-in routine definition acquisition requests (# OF PLG-RTN GET REQ)
- Tuning procedure
- Obtain the plug-in routine definition cache hit rate with the following formula, and tune it so that the hit rate becomes 100%:
- Plug-in routine definition cache hit rate (%) =
- (plug-in routine definition cache hits count
number of plug-in routine definition acquisition requests)
100
- Actions to be taken
- Increase the value of the pd_routine_def_cache_size operand.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.