Back to results
US 2021/0081399 A1Published application
Automatic reclamation of storage space for database systems
AssigneeOracle International Corporation
InventorsTeck Hua LEE, Tirthankar LAHIRI, Yunrui LI
Life of this patent
Estimating the term…
Abstract
An approach is described to provide a method, a computer program product, and a computer system to implement hole punching. The described approach provides an automated way to free up space without requiring manual intervention by a DBA to manually reorganize database objects to free up space.
Claims27
A method, comprising:
- identifying a free extent in a database system, wherein a physical storage is allocated to the free extent at a physical storage layer;
- determining that the free extent is a hole that is located between two allocated extents within a file;
- determining whether a database consistency problem will exist if the free extent is disassociated from the physical storage;
- and
- deallocating the physical storage from the free extent after making a determination whether the database consistency problem will occur if the free extent is disassociated from the physical storage.
2 more elements
A system, comprising:
- a processor;
- a memory for holding programmable code;
- and
- wherein the programmable code includes instructions executable by the processor for identifying a free extent in a database system, wherein a physical storage is allocated to the free extent at a physical storage layer;
- determining that the free extent is a hole that is located between two allocated extents within a file;
- determining whether a database consistently problem will exist if the free extent is disassociated from the physical storage;
- and deallocating the physical storage from the free extent after making a determination whether the database consistency problem will occur if the free extent is disassociated from the physical storage.
4 more elements
A computer program product embodied on a computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor, executes a method comprising:
- identifying a free extent in a database system, wherein a physical storage is allocated to the free extent at a physical storage layer;
- determining that the free extent is a hole that is located between two allocated extents within a file;
- determining whether a database consistently problem will exist if the free extent is disassociated from the physical storage;
- and
- deallocating the physical storage from the free extent after making a determination whether the database consistency problem will occur if the free extent is disassociated from the physical storage.
2 more elements
Dependencies are inferred from the claim text.