发明授权
- 专利标题: Multi-phase locking for partition maintenance operations
- 专利标题(中): 用于分区维护操作的多相锁定
-
申请号: US887963申请日: 1997-07-03
-
公开(公告)号: US6105026A公开(公告)日: 2000-08-15
- 发明人: Andre Kruglikov , Elizabeth Davis , Gianfranco Putzolu
- 申请人: Andre Kruglikov , Elizabeth Davis , Gianfranco Putzolu
- 申请人地址: CA Redwood City
- 专利权人: Oracle Corporation
- 当前专利权人: Oracle Corporation
- 当前专利权人地址: CA Redwood City
- 主分类号: G06F17/30
- IPC分类号: G06F17/30
摘要:
A method and apparatus for multi-phase locking for partition maintenance operations. In the first phase, a shared data dictionary lock is acquired on a body of metadata in a data dictionary. Next, the data dictionary is read and a list of affected partitions is generated. In the second phase, an intent exclusive data lock is acquired on the affected table. Next, an exclusive data lock is acquired on the affected partitions of the affected table. The shared data dictionary lock on the data dictionary is released and a physical attribute of the data of the affected partitions is changed. In the third phase, an exclusive data dictionary lock is acquired on the data dictionary. The metadata associated with the affected partitions in the data dictionary is updated and the exclusive data locks on the affected partitions and the intent exclusive data lock on the affected table are released. Finally, the exclusive data dictionary lock on the data dictionary is released. As a result of performing multi-phase locking for partition maintenance operations, the scope of resources locked is reduced and the efficiency of the partition maintenance operations, from a concurrency point of view, is increased.
公开/授权文献
信息查询