Oracle International Corporation

Haranadh Poduri

Karl Dias

Leonidas Galanis

Yujun Wang

Mughees Minhas

Prabhaker Gongloor

Systems, methods, and other embodiments associated with continuous capture of replayable workload for a database are described. In one embodiment, a method includes capturing workload units being executed on a production database and storing the captured workload units in a circular workload buffer. The circular workload buffer is configured to write newest captured workload units over oldest workload units in the workload buffer when the workload buffer becomes full. The method includes, in response to detecting an event, exporting contents of the workload buffer to offline memory. The exporting includes at least one I/O operation. In one embodiment, an advisor feature guides set up of the continuous capture feature by providing historical workload data and making recommendations regarding an amount of memory that should be allocated to the workload buffer.

Growing community of inventors

Foster City, CA, United States of America

Haranadh Poduri