6.9 Estimating the size of an SQL trace file

This section explains how to estimate the size of an SQL trace file.

Use the following formula to determine the size of an SQL trace file.

Formula (kilobytes)

Explanation of the variables

sqltxt_size

Value specified for the adb_sql_trc_txtfile_size operand in the server definition

For details, see the explanation of the adb_sql_trc_txtfile_size operand in 7.2.5 Operands related to SQL statements (set format).

To Page Top