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 will be available on generic Linux platforms in January and soon on AIX and Windows

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