Capturing and restoring database session state
First Claim
1. A computer-implemented method comprising steps of:
- determining that a database session in a first database server is at a transaction boundary;
in response to determining that said database session is at a transaction boundary, capturing a session state of said database session;
after capturing said session state, capturing a workload that is processed in said database session by said first database server;
recreating, based on said session state, said database session in a second database server that is separate from said first database server; and
replaying at least a portion of said workload in said recreated database session in said second database server.
0 Assignments
0 Petitions
Accused Products
Abstract
Techniques are described herein for capturing and restoring database session state. Production database server components save the session state of each of a plurality of database sessions. The components store workload units that are processed in these sessions. The components store updated session states in response to certain events. Thus, the components may capture multiple session states, pertaining to various different points in time, for each session. The captured session states and the captured workload are moved to a test database server. A user selects, from among the time points represented by the session states, a point in time at which the user would like workload replay to begin. Sessions are re-created on the test database server. Session states of these sessions are set to reflect the session states as they existed at the user-selected time point. Workload units are replayed in the sessions relative to the test database server.
-
Citations
16 Claims
-
1. A computer-implemented method comprising steps of:
-
determining that a database session in a first database server is at a transaction boundary; in response to determining that said database session is at a transaction boundary, capturing a session state of said database session; after capturing said session state, capturing a workload that is processed in said database session by said first database server; recreating, based on said session state, said database session in a second database server that is separate from said first database server; and replaying at least a portion of said workload in said recreated database session in said second database server. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A non-transitory computer-readable medium storing one or more sequences of instructions which, when executed by one or more processors, cause:
-
determining that a database session in a first database server is at a transaction boundary; in response to determining that said database session is at a transaction boundary, capturing a session state of said database session; after capturing said session state, capturing a workload that is processed in said database session by said first database server; recreating, based on said session state, said database session in a second database server that is separate from said first database server; and replaying at least a portion of said workload in said recreated database session in said second database server. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
Specification