Invention Grant
- Patent Title: Avoiding lock contention by using a wait for completion mechanism
- Patent Title (中): 通过使用等待完成机制避免锁争用
-
Application No.: US11830538Application Date: 2007-07-30
-
Publication No.: US07644106B2Publication Date: 2010-01-05
- Inventor: Shrikanth Shankar , Ramesh Kumar , Amirali S. Valiani , Vasudha Krishnaswamy , Ananth Raghavan , Juan R. Loaiza
- Applicant: Shrikanth Shankar , Ramesh Kumar , Amirali S. Valiani , Vasudha Krishnaswamy , Ananth Raghavan , Juan R. Loaiza
- 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 Truong & Becker LLP
- Agent Daniel D. Ledesma
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Techniques for avoiding lock contention when processing data definition language (DDL) statements are provided. Some DDL statements modify metadata of a table and then require access to the table. After such a DDL statement modifies the metadata of a table and the updated metadata is made available (i.e., published) to other database statements, execution of the DDL statement is suspended. Data manipulation language (DML) statements acquire locks on the table. In one approach, the locks, of any DML statement, that are granted after the DDL statement is issued are timestamped. The DDL statement uses the timestamps to determine when to access the table. The timestamps are used to determine when the last DML statement (that was pending at the time the modified metadata was published) commits and releases its lock on the table.
Public/Granted literature
- US20090037417A1 AVOIDING LOCK CONTENTION BY USING A WAIT FOR COMPLETION MECHANISM Public/Granted day:2009-02-05
Information query