Invention Grant
- Patent Title: Space management for transactional consistency of in-memory objects on a standby database
-
Application No.: US15892677Application Date: 2018-02-09
-
Publication No.: US10747752B2Publication Date: 2020-08-18
- Inventor: Vasudha Krishnaswamy , Kartik Kulkarni , Sukhada Pendse , Akshay Kulkarni
- 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
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/23 ; G06F16/27 ; G06F3/06 ; G06F16/25 ; G06F11/00 ; G06F11/20 ; G06F11/14 ; G06F11/16

Abstract:
Embodiments store transaction metadata in dedicated pools of allocated memory chunks. Portions of the pools of allocated memory chunks are dedicated to the respective apply slave processes that mine and process change records. Also, the pools of allocated memory chunks are anchored within the structure of a transaction log such that buffering and application of metadata for one transaction does not block required buffering and application of metadata for other transactions. The standby database system pre-processes transaction metadata in preparation for application of the metadata to invalidate appropriate portions of MF data. Further, embodiments divide the work of pre-processing invalidation records among the many apply slave processes that record the invalidation records. A garbage collection selects memory chunks for garbage collection in reverse order of how the chunks were allocated. Also, a deduplication algorithm ensures that typically only a single invalidation message per block is applied to invalidate MF data.
Public/Granted literature
- US20180165324A1 SPACE MANAGEMENT FOR TRANSACTIONAL CONSISTENCY OF IN-MEMORY OBJECTS ON A STANDBY DATABASE Public/Granted day:2018-06-14
Information query