Oracle | DBMS_REPLAYHUB

Oracle DBMS_REPLAYHUB Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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