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
AWR Server Host Utilities
Procedures cannot be replicated by LogMiner via regular DML/DDL apply (replication of SYS schema is not supported) nor using 'Procedural replication'
(re-invoking the procedure at the logical standby produce different results).
Designates the database it runs on as an AWRHub server that will store AWR data uploaded by its sources
dbms_awrhub.create_server(
hub_name IN VARCHAR2,
hub_mailbox IN VARCHAR2,
mailbox_type IN VARCHAR2 DEFAULT 'FILE_SYSTEM',
mailbox_cred IN VARCHAR2 DEFAULT NULL,
cred_owner IN VARCHAR2 DEFAULT NULL);
dbms_awrhub.modify_hub_settings(
hub_name IN VARCHAR2,
sweep_interval IN NUMBER DEFAULT NULL,
dflt_upload_snap_cnt IN NUMBER DEFAULT NULL,
dflt_hub_retention IN NUMBER DEFAULT NULL,
dflt_hub_tablespace IN VARCHAR2 DEFAULT NULL,
num_conc_imp IN NUMBER DEFAULT NULL,
max_run_time IN NUMBER DEFAULT NULL,
consumer_group IN VARCHAR2 DEFAULT NULL);
Modifies settings of the hub services for the specified Source DB
dbms_awrhub.modify_source_settings(
hub_name IN VARCHAR2,
source_name IN VARCHAR2,
hub_service IN VARCHAR2 DEFAULT 'SNAPSHOT',
upload_snap_cnt IN NUMBER DEFAULT NULL,
hub_retention IN NUMBER DEFAULT NULL,
hub_tablespace IN VARCHAR2 DEFAULT NULL);
Configures the database where it runs as an AWRHub source of the specified hub
dbms_awrhub.register_source(
hub_name IN VARCHAR2,
source_name IN VARCHAR2 DEFAULT NULL,
hub_mailbox IN VARCHAR2,
mailbox_type IN VARCHAR2 DEFAULT 'FILE_SYSTEM',
mailbox_cred IN VARCHAR2 DEFAULT NULL,
cred_owner IN VARCHAR2 DEFAULT NULL);
Configures a cloud access method that can be used by AWRHub to transfer files between a local File System and the Oracle Object Store
dbms_awrhub.setup_cloud_access(
access_method IN VARCHAR2,
exec_path IN VARCHAR2 DEFAULT NULL,
remote_user IN VARCHAR2 DEFAULT NULL,
remote_machine IN VARCHAR2 DEFAULT NULL);
Setups up a cache mailbox for AWRHub source. A source cache mailbox is a temporary location for mail packages to be put in before exported to the hub mailbox.
dbms_awrhub.setup_source_cache_mailbox(
hub_name IN VARCHAR2,
cache_mailbox IN VARCHAR2 DEFAULT NULL);
Setups a cache mailbox for AWRHub source. A source cache mailbox is a temporary location for mail packages to be put in before exported to the hub mailbox
dbms_awrhub.setup_server_cache_mailbox(
hub_name IN VARCHAR2,
source_name IN VARCHAR2 DEFAULT NULL,
cache_mailbox IN VARCHAR2 DEFAULT NULL);