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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AWRHUB
DBMS_AWRHUB_SERVER
DBMS_AWRHUB_SOURCE
DBMS_RAT_MASK
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_CAPTURE_I
DBMS_WORKLOAD_REPLAY
DBMS_WORKLOAD_REPLAY_I
DBMS_WRR_INTERNAL
DBMS_WRR_STATE_BASE

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx