Oracle | DBMS_REPLAYHUB

Oracle DBMS_REPLAYHUB Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Registers an Oracle database as a Source to a ReplayHub. Once the registration is successful, the database can upload Real Application Testing (RAT) workload capture to the ReplayHub or download workloads for replay to other Oracle databases.

AUTHID CURRENT_USER

Dependencies

DBMS_AWRHUB

DBMS_WORKLOAD_CAPTURE_LIB

DBMS_WORKLOAD_REPLAY_LIB

Documented No

First Available 20c

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(DEFAULT, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to the DBA role.

Source {ORACLE_HOME}/rdbms/admin/dbmswrr.sql
{ORACLE_HOME}/rdbms/admin/prvtwrr.plb

Subprograms

CALIBRATE	INSTALL_WORKLOAD	STOP_CAPTURE
CANCEL_REPLAY	REGISTER_SOURCE	UNINSTALL_WORKLOAD
CAPTURE_WORKLOAD	REPLAY	UNREGISTER_SOURCE
CREATE_SERVER	REPLAY_REPORT	UPLOAD_WORKLOAD
DROP_SERVER

CALIBRATE

Computes the approximate number of replay clients and CPUs needed to replay a given workload dbms_replayhub.calibrate(rep_workload_name IN VARCHAR2) RETURN CLOB;

SELECT dbms_replayhub.calibrate('UWReplayWL');

      

      PL/SQL procedure successfully completed.

CANCEL_REPLAY(new 23ai parameters)

Cancel the replay in progress dbms_replayhub.cancel_replay( replay_name IN VARCHAR2, reason IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.cancel_replay('Because I Want To');

CAPTURE_WORKLOAD (new 23ai)

Capture a workload which involves recording all external client requests to the database dbms_replayhub.capture_workload( workload_name IN VARCHAR2, duration IN NUMBER); -- in seconds

SELECT dbms_replayhub.capture_workload('UWWKLDCAP', 600);

      

      PL/SQL procedure successfully completed.

CREATE_SERVER

Designate the database it runs on as a ReplayHub server that can store captured workloads uploaded by one or more sources dbms_replayhub.create_server( hub_name IN VARCHAR2, hub_mailbox IN VARCHAR2, mailbox_type IN VARCHAR2 DEFAULT 'FILE_SYSTEM', mailbox_cred IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.create_server('UWWCRH', 'RHMBOX');

      

      PL/SQL procedure successfully completed.

DROP_SERVER

Drop ReplayHub server previously created in the database dbms_replayhub.drop_server(hub_name IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.drop_source('UWWCRH');

      

      PL/SQL procedure successfully completed.

INSTALL_WORKLOAD (new 23ai parameters)

Install workload from ReplayHub into the current database dbms_replayhub.install_workload( hub_name IN VARCHAR2 DEFAULT NULL, source_name IN VARCHAR2 DEFAULT NULL, workload_dbid IN NUMBER, workload_name IN VARCHAR2, rep_workload_name IN VARCHAR2 DEFAULT NULL);

TBD

REGISTER_SOURCE

Register the current database as a Source for a ReplayHub dbms_replayhub.register_source( hub_name IN VARCHAR2, hub_mailbox IN VARCHAR2, mailbox_type IN VARCHAR2 DEFAULT 'FILE_SYSTEM', mailbox_cred IN VARCHAR2 DEFAULT NULL, source_name IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.register_source('UWWCRH', 'RHMBOX', 'FILE_SYSTEM', source_name=>'ORABASE23');

      

      PL/SQL procedure successfully completed.

REPLAY (new 23ai parameters)

Replay the specified workload capture dbms_replayhub.replay( rep_workload_name IN VARCHAR2, replay_name IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.replay('Replay Test 42', 'UWReplayWL');

      

      PL/SQL procedure successfully completed.

REPLAY_REPORT (new 23ai)

Return the Replay Report dbms_replayhub.replay_report(replay_name IN VARCHAR2) RETURN CLOB;

SELECT dbms_replayhub.

      
      

      PL/SQL procedure successfully completed.

STOP_CAPTURE (new 23ai)

Stop the current capture and prevent future requests to the database from being recorded dbms_replayhub.stop_capture;

SELECT dbms_replayhub.

      
      

      PL/SQL procedure successfully completed.

UNINSTALL_WORKLOAD (new 23ai)

Uninstall a workload from the current database dbms_replayhub.uninstall_workload(rep_workload_name IN VARCHAR2);

TBD

UNREGISTER_SOURCE

Unregisters a ReplayHub dbms_replayhub.unregister_source( hub_name IN VARCHAR2 DEFAULT NULL, source_name IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.unregister_source('UWWCRH', 'ORABASE23');

      

      PL/SQL procedure successfully completed.

UPLOAD_WORKLOAD (new 23ai parameters)

Upload workload capture to the current ReplayHub dbms_replayhub.upload_workload( hub_name IN VARCHAR2 DEFAULT NULL, source_name IN VARCHAR2 DEFAULT NULL, workload_name IN VARCHAR2);

TBD