Oracle | DBMS_REPLAYHUB

Oracle DBMS_REPLAYHUB Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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_ASSERT	DBMS_WORKLOAD_CAPTURE_LIB	V$PARAMETER
DBMS_AWRHUB	DBMS_WORKLOAD_REPLAY	XMLTYPE
DBMS_AWRHUB_SOURCE	DBMS_WRR_INTERNAL	XQSEQUENCE
DBMS_STANDARD

Documented No

First Available 20c

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(CANCEL_REPLAY, UNSUPPORTED_WITH_COMMIT);

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

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

Subprograms

CALIBRATE	DROP_SERVER	REPLAY
CANCEL_REPLAY	INSTALL_WORKLOAD	UNREGISTER_SOURCE
CREATE_SERVER	REGISTER_SOURCE	UPLOAD_WORKLOAD

CALIBRATE (new 20c)

Computes the approximate number of replay clients and CPUs needed to replay a given workload dbms_replayhub.calibrate(workload_name IN VARCHAR2) RETURN CLOB; PRAGMA SUPPLEMENTAL_LOG_DATA(CALIBRATE, READ_ONLY);

SELECT dbms_replayhub.calibrate('UWReplayWL')

      FROM dual;

CANCEL_REPLAY (new 20c)

Cancel the replay in progress dbms_replayhub.cancel_replay(reason IN VARCHAR2 DEFAULT NULL); PRAGMA SUPPLEMENTAL_LOG_DATA(CANCEL_REPLAY, UNSUPPORTED_WITH_COMMIT);

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

CREATE_SERVER (new 20c)

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');

DROP_SOURCE (new 20c)

Drop the existing ReplayHub dbms_replayhub.drop_source(hub_name IN VARCHAR2 DEFAULT NULL);

exec dbms_replayhub.drop_source('UWWCRH');

INSTALL_WORKLOAD (new 20c)

Install workload from ReplayHub into the current database dbms_replayhub.install_workload(workload_name IN VARCHAR2); PRAGMA SUPPLEMENTAL_LOG_DATA(INSTALL_WORKLOAD, UNSUPPORTED_WITH_COMMIT);

exec dbms_replayhub.install_workload('UWReplayWL');

REGISTER_SOURCE (new 20c)

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=>'ORABASE21');

REPLAY (new 20c)

Replay the specified workload capture dbms_replayhub.replay( replay_name IN VARCHAR2, workload_name IN VARCHAR2); PRAGMA SUPPLEMENTAL_LOG_DATA(REPLAY, UNSUPPORTED_WITH_COMMIT);

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

UNREGISTER_SOURCE (new 20c)

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', 'ORABASE21');

UPLOAD_WORKLOAD (new 20c)

Upload workload capture to the current ReplayHub dbms_replayhub.upload_workload(capture_id IN NUMBER);

exec dbms_replayhub.upload_workload(42);