Hitachi

Hitachi Advanced Database Setup and Operation Guide


6.8 Estimating the size of a statistics log file

This section explains how to estimate the size of a statistics log file.

Use the following formula to determine the size of a statistics log file.

Formula (kilobytes)
size-of-statistics-log-file = sta_log_max_size × sta_log_size_unit × 1,024 × 4 + 1,024

Explanation of the variables

sta_log_max_size

Value specified for the adb_sta_log_max_size operand in the server definition

For details, see the description of the adb_sta_log_max_size operand in 7.2.7 Operands related to statistical information (set format).

sta_log_size_unit
  • If the adb_sta_log_size_unit operand is omitted or G is specified for the adb_sta_log_size_unit operand in the server definition:

    Substitute 1,024.

  • If M is specified for the adb_sta_log_size_unit operand in the server definition:

    Substitute 1.

For details about the adb_sta_log_size_unit operand in the server definition, see the description of the adb_sta_log_size_unit operand in 7.2.7 Operands related to statistical information (set format).

Note that the output destination of statistics log files differs depending on whether the adb_sta_log_path operand is specified in the server definition.

For details about the adb_sta_log_path operand in the server definition, see the description of the adb_sta_log_path operand in 7.2.7 Operands related to statistical information (set format).