US 12,007,941 B2
Session state tracking
Kevin S. Neel, San Mateo, CA (US); Carol L. Colrain, Redwood Shores, CA (US); Tong Zhou, Merrick, NY (US); Arturo Ismael Quinto, Guadalajara (MX); Jonathan Giloni, Foster City, CA (US); Douglas Surber, Orinda, CA (US); and Ravi Thammaiah, Redwood Shores, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Sep. 28, 2018, as Appl. No. 16/147,314.
Claims priority of provisional application 62/566,253, filed on Sep. 29, 2017.
Prior Publication US 2019/0102401 A1, Apr. 4, 2019
Int. Cl. G06F 16/14 (2019.01); G06F 11/20 (2006.01); G06F 16/11 (2019.01); G06F 16/21 (2019.01); G06F 16/25 (2019.01); H04L 67/141 (2022.01); H04L 67/142 (2022.01)
CPC G06F 16/122 (2019.01) [G06F 11/2023 (2013.01); G06F 16/21 (2019.01); G06F 16/252 (2019.01); H04L 67/141 (2013.01); H04L 67/142 (2013.01); G06F 2201/80 (2013.01)] 26 Claims
OG exemplary drawing
 
1. A computer-implemented method comprising:
capturing a state of a database session by receiving a session state summary caused by execution of one or more commands on a first database server of a database management system (DBMS), the session state summary comprising a restorable session state summary and a non-restorable session state summary;
wherein the non-restorable session state summary represents one or more non-restorable aspects of the database session which cannot be restored by a request to the DBMS;
generating a verification point associated with the session state summary, the verification point indicating that the session state summary includes information to determine that a replay of the one or more commands yields a session state change, which is identical to a change in the state of the database session caused by the execution of the one or more commands;
determining whether the non-restorable session state summary includes a modified state;
based at least in part on determining that the non-restorable session state summary fails to include a modified state, determining that the verification point is a safe point;
based on the determining that the verification point is a safe point, deleting information for a replay of the one or more commands and previously recorded commands.