The following shows the formulas for estimating the PreparedStatement object size.

Formula (for 32-bit mode)

PreparedStatement object size = 39000 + (2100 + input data storage area size + retrieval results storage area size) x number of PreparedStatement instances (bytes)

Formula (for 64-bit mode)

PreparedStatement object size = 40000 + (2600 + input data storage area size + retrieval results storage area size) x number of PreparedStatement instances (bytes)

Input data storage area size: If ? parameters are used, use the following formula to determine the value:

The retrieval results storage area size is the same as for the Statement object.