US 12,405,747 B2
Dynamic page fix optimization for database objects
Donnell W. Roach, Houston, TX (US)
Assigned to BMC Software, Inc., Houston, TX (US)
Filed by BMC Software, Inc., Houston, TX (US)
Filed on Feb. 17, 2023, as Appl. No. 18/171,104.
Prior Publication US 2024/0281168 A1, Aug. 22, 2024
Int. Cl. G06F 3/06 (2006.01); G06F 12/08 (2016.01)
CPC G06F 3/0656 (2013.01) [G06F 3/0613 (2013.01); G06F 3/0683 (2013.01); G06F 12/08 (2013.01); G06F 2212/254 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A computer program product, the computer program product being tangibly embodied on a non-transitory computer-readable storage medium and comprising instructions that, when executed by at least one computing device, are configured to cause the at least one computing device to:
monitor a main memory of the at least one computing device to determine available main memory for a fixed buffer pool storing a first set of data objects accessible by an application;
monitor a virtual buffer pool stored in a secondary memory of the at least one computing device and storing a second set of data objects accessible by the application;
generate object performance profiles that include an object performance profile for each data object of the second set of data objects;
determine a transfer trigger for selecting a candidate transfer object from the second set of data objects for transfer to the main memory, based on the object performance profiles; and
transfer the candidate transfer object from the secondary memory to the fixed buffer pool to be included in the first set of data objects, in response to the transfer trigger.