International Business Machines Corporation
Dynamic management of memory allocation in a database

Abstract:

A method is provided for managing memory allocation in a database. The method determines a preferred statement among defined statements with defined sizes of objects. The defined statements include (i) a stored statement defined to allocate the objects and stored in the database wherein each of the objects have a stored size, and (ii) alternative stored statements that provide an alternative of the stored statement defined to allocate the objects with alternative sizes lower than stored sizes. The preferred statement has defined sizes compliant to actual sizes according to preference criterion. The method invokes the preferred statement for execution in place of the stored statement when different. The method stores a new statement, having new sizes compliant to actual sizes according to alternate criterion, responsive to unfulfilling a condition based on comparing defined sizes of the preferred statement with actual sizes.