公开(公告)号：US09104739B2

公开(公告)日：2015-08-11

申请号：US13852986

申请日：2013-03-28

Applicant: Oracle International Corporation

Inventor： Chao Liang ,  Feng Cao ,  Rajendra Pingte

IPC: G06F17/30 ,  G06F11/34

CPC classification number: G06F17/30575 ,  G06F11/3414 ,  G06F11/3495 ,  G06F2201/86 ,  G06F2201/87

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.

Abstract translation: 这里描述了用于捕获和恢复数据库会话状态的技术。 生产数据库服务器组件保存多个数据库会话中的每一个的会话状态。 组件存储在这些会话中处理的工作负载单元。 组件存储更新的会话状态以响应某些事件。 因此，组件可以针对每个会话捕获属于各种不同时间点的多个会话状态。 捕获的会话状态和捕获的工作负载被移动到测试数据库服务器。 用户从由会话状态表示的时间点中选择用户想要工作负载重放开始的时间点。 会话在测试数据库服务器上重新创建。 这些会话的会话状态被设置为反映在用户选择的时间点存在的会话状态。 在相对于测试数据库服务器的会话中重播工作负载单元。

公开(公告)号：US20130232113A1

公开(公告)日：2013-09-05

申请号：US13852986

申请日：2013-03-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Chao Liang ,  Feng Cao ,  Rajendra Pingte

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F11/3414 ,  G06F11/3495 ,  G06F2201/86 ,  G06F2201/87

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.

Abstract translation: 这里描述了用于捕获和恢复数据库会话状态的技术。 生产数据库服务器组件保存多个数据库会话中的每一个的会话状态。 组件存储在这些会话中处理的工作负载单元。 组件存储更新的会话状态以响应某些事件。 因此，组件可以针对每个会话捕获属于各种不同时间点的多个会话状态。 捕获的会话状态和捕获的工作负载被移动到测试数据库服务器。 用户从会话状态所表示的时间点中选择用户想要工作负载重放开始的时间点。 会话在测试数据库服务器上重新创建。 这些会话的会话状态被设置为反映在用户选择的时间点存在的会话状态。 在相对于测试数据库服务器的会话中重播工作负载单元。