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