Invention Grant
- Patent Title: Recovering stateful read-only database sessions
-
Application No.: US13936061Application Date: 2013-07-05
-
Publication No.: US09779116B2Publication Date: 2017-10-03
- Inventor: Carol L. Colrain , Kevin S. Neel , Tong Zhou , Douglas N. Surber , Stefan Heinrich Roesch , Nancy R. Ikeda , Paul Parkinson
- 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: G06F17/30
- IPC: G06F17/30

Abstract:
A process, apparatus, and computer-readable medium are provided for rebuilding a database session when a previous database session becomes unavailable and the commands previously sent for execution on the previous database session satisfy certain criteria. The process includes determining whether or not a set of commands sent by a client for execution on the previous database session is acceptable to replay based at least in part on whether or not the set of commands satisfies one or more criteria. The process further includes determining that the previous database session is unavailable due to a planned or unplanned recoverable error. In response to determining that the previous database session is unavailable, if the set of commands is acceptable for replay, the set of commands is sent for execution on a new database session to rebuild the state, which was exposed to the client from the previous database session, on the new database session. The process masks the outage from the application.
Public/Granted literature
- US20160321304A9 RECOVERING STATEFUL READ-ONLY DATABASE SESSIONS Public/Granted day:2016-11-03
Information query