Estimating the size of trace objects

Nonstop Database, HiRDB Version 9 UAP Development Guide

The total size of trace objects is equal to the total amount of memory required for collecting the following troubleshooting information:

Organization of this subsection: (1) Interface method traces; (2) Estimating the size of Exception trace logs; (3) Estimating the size of SQL traces

Add this value if you collect interface method traces.

Formula

Size of interface method traces = 300 x number of entries x number of Connection instances
(bytes)

Number of entries: Either of the following values, as appropriate:

Value of the url argument in DriverManager.getConnection or the value of the TRC_NO user property
Value specified in the setTRC_NO method of a DataSource interface

Add this value when the acquisition level for Exception trace logs is not 0.

Formula

Size of Exception trace logs = 360 x number of data items to be collected in memory (bytes)

Number of data items to be collected in memory: The value is one of the following:

Add this value if you collect SQL traces.

Formula

Size of SQL traces = 10,000 x number of Connection instances (bytes)