US 12,314,229 B2
Tracking row and object database activity into block level heatmaps
Vineet Marwah, San Ramon, CA (US); Sujatha Muthulingam, Sunnyvale, CA (US); and Amit Ganesh, San Jose, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Aug. 22, 2023, as Appl. No. 18/236,775.
Application 18/236,775 is a continuation of application No. 16/861,180, filed on Apr. 28, 2020, granted, now 11,741,054.
Application 16/861,180 is a continuation of application No. 13/804,884, filed on Mar. 14, 2013, granted, now 10,678,760, issued on Jun. 9, 2020.
Claims priority of provisional application 61/707,685, filed on Sep. 28, 2012.
Prior Publication US 2023/0394012 A1, Dec. 7, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 3/06 (2006.01); G06F 16/11 (2019.01); G06F 16/185 (2019.01); G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/27 (2019.01)
CPC G06F 16/185 (2019.01) [G06F 3/0649 (2013.01); G06F 16/113 (2019.01); G06F 16/21 (2019.01); G06F 16/217 (2019.01); G06F 16/22 (2019.01); G06F 16/27 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method comprising:
persisting a plurality of map blocks, wherein each map block of the plurality of map blocks contains a mapping from each LBA range of a respective plurality of ranges of logical block addresses (LBAs) to a respective statistics block that contains access activity statistics that include an access timestamp for each data block of a plurality of data blocks in the LBA range, wherein said plurality of data blocks store database data for a database object in a database, wherein activity tracked by said access activity statistics includes read accesses;
accessing a plurality of statistic blocks that are indicated by said mappings in a subset plurality of the persisted plurality of man blocks,
detecting, based on said plurality of statistic blocks that are indicated by said mappings in said subset plurality of the persisted plurality of map blocks and without accessing a plurality of data blocks in the database object, whether the database object has or has not been accessed since a particular time; and
archiving the plurality of data blocks in response to said detecting whether the database object has or has not been accessed.