Inventors:
Romain Colle - San Francisco CA, US
Karl Dias - Foster City CA, US
Leonidas Galanis - San Jose CA, US
Supiti Buranawatanachoke - San Mateo CA, US
Jonathan Giloni - Foster City CA, US
Efstratios Papadomanolakis - San Francisco CA, US
Yujun Wang - Cupertino CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
Abstract:
A method, apparatus, and computer-readable medium is provided for replaying captured workload data in a database environment with connection pools. A replay system includes a dispatcher that manages a connection pool. In one aspect, the dispatcher selects available connections for sending database commands that are ready to be executed against a database, but prevents from being sent, or holds, commands that are not ready to be executed against the database. Commands may be stored at the dispatcher until the database advances to a state that allows the commands to be executed. In another aspect, the dispatcher may use an available connection to send a command to a database instance even though the command is not ready to be executed, as long as at least a threshold number or percentage of connections remains available.