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
Constants
Name
Data Type
Value
General
???
Data Types
???
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
Exceptions
Error Code
Reason
First Available
20c
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);
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);