Patent ID: 11936739
Assignee: ORACLE INTERNATIONAL CORPORATION
Field: Digital communication (Electrical engineering)
Classification: CPC H  G | IPC G  H

Claim 8:
9. One or more non-transitory computer-readable media storing instructions, wherein the instructions include a set of instructions, which when executed by one or more hardware processors, cause:
receiving a request from a client application to execute one or more commands within a session with a database management system (DBMS), the request having a begin request boundary and an end request boundary;
identifying that the end request boundary for the request is reached within the same session or a next begin request boundary for a next request is detected within the same session;
based on the identifying that the end request boundary is reached within the same session or the next begin request boundary is detected within the same session, verifying that the end request boundary or the next begin request boundary is at a resettable point of a session state of the session, wherein the verifying comprises:
determining whether any transactional object is instantiated in the session,
if it is determined that a transactional object is instantiated for a transaction,
requesting a rollback of the transaction, and
if it is determined that no transactional object is instantiated,
determining that the end request boundary or the next begin request boundary is at a resettable point of the session state of the session;
based at least in part on verifying that the end request boundary or the next begin request boundary is at a resettable point of the session state of the session:
determining, based on session reset configuration data corresponding to the session, one or more session attributes from a plurality of session attributes of the session state of the session to reset, and
based, at least in part, on the session reset configuration data, performing a reset of the session state of the session at least by resetting the one or more session attributes of the session state of the session.