Invention Grant
- Patent Title: Dropping an index without blocking locks
-
Application No.: US14231416Application Date: 2014-03-31
-
Publication No.: US10698723B2Publication Date: 2020-06-30
- Inventor: Ramesh Kumar , Ananth Raghavan , George Eadon
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Becker Bingham LLP
- Agent Daniel D. Ledesma
- Main IPC: G06F9/46
- IPC: G06F9/46 ; G06F16/22 ; G06F16/23

Abstract:
Techniques for processing “destructive” database statements are provided. Destructive database statements, when processed, cause metadata of a database object to be changed. Examples of such database statements include ones that delete an index, that set a column as unused, and that drop a constraint on a column. When such a statement is received, a change is made to metadata of a database object. Such a metadata change may involve setting an index as unusable, disabling a constraint, or invalidating a cursor. After the metadata change, a first time is determined. Then, it is determined when one or more database transactions that were pending at the first time have committed. After those database transaction(s) have committed, one or more operations are performed, such as dropping an index or dropping a constraint.
Public/Granted literature
- US20150278275A1 DROPPING AN INDEX WITHOUT BLOCKING LOCKS Public/Granted day:2015-10-01
Information query