Tuning the buffer length for user-defined type information

Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents]

[Index]

[Back]

[Next]

23.5.5 Tuning the buffer length for user-defined type information

This section explains tuning of the buffer length for user-defined type information (pd_type_def_cache_size operand value).

Organization of this subsection: (1) Tuning method (1); (2) Tuning method (2)

(1) Tuning method (1)

Information to be referenced

See the following system activity statistical information provided by the statistics analysis utility:

Type definition cache hits count (# OF TYPE-DEF CACHE HIT)
Number of type definition information acquisition requests (# OF TYPE-DEF GET REQ)

Tuning procedure: Obtain the type definition cache hit rate with the following formula, and tune it so that the hit rate becomes 100%:; Type definition cache hit rate (%) =; (type definition cache hits count number of type definition information acquisition requests) 100

Actions to be taken: Increase the value of the pd_type_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:

Total type definitions cache size (TYPE-DEF CACHE TOTAL SIZE)
Allocated type definition cache size (TYPE-DEF CACHE ALLOC SIZE)

Tuning procedure: Obtain the type definition cache utilization factor with the following formula, and tune it so that the utilization factor becomes 90% or higher:; Type definition cache utilization factor (%) =; (maximum value of total type definitions cache size allocated type definition cache size) 100

Actions to be taken: Reduce the value of the pd_type_def_cache_size operand.

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.