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
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).
Owned by SYS with EXECUTE granted to the DBA role.
Source
{ORACLE_HOME}/rdbms/admin/dbmsawr.sql
Subprograms
CREATE_SERVER
REGISTER_SOURCE
SETUP_SOURCE_CACHE_MAILBOX
DROP_SERVER
SETUP_SERVER_CACHE_MAILBOX
UNREGISTER_SOURCE
CREATE_SERVER (new 21c)
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.drop_server(hub_name IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub.drop_server('UWAWRHUB');
REGISTER_SOURCE (new 21c)
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);
Setups up a cache mailbox for AWRHub source. A source cache mailbox is a temporary location for mailpkgs to be put in before exported to the hub mailbox.
dbms_awrhub.setup_source_cache_mailbox(
hub_name IN VARCHAR2,
source_name IN VARCHAR2 DEFAULT NULL,
cache_mailbox IN VARCHAR2 DEFAULT NULL);