Oracle | DBMS

Oracle DBMS_AWRHUB 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 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).

AUTHID CURRENT_USER

Dependencies

DBMS_AWRHUB_SERVER

DBMS_AWRHUB_SOURCE

DBMS_REPLAYHUB

Documented No

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

First Available 21c

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

exec dbms_awrhub.create_server('UWAWRHUB', 'AWR_HUB_MAIL');

DROP_SERVER (new 21c)

Drops the previously created server 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);

exec dbms_awrhub.register_source('UWAWRHUB', NULL, 'AWR_HUB_MAIL');

SETUP_SERVER_CACHE_MAILBOX (new 21c)

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

exec dbms_awrhub.setup_source_cache_mailbox('UWAWRHUB');

SETUP_SOURCE_CACHE_MAILBOX (new 21c)

Setups a cache mailbox for AWRHub source. A source cache mailbox is a temporary location for mailpkgs to be put in beforeexported to the hub mailbox dbms_awrhub.setup_server_cache_mailbox( hub_name IN VARCHAR2, cache_mailbox IN VARCHAR2 DEFAULT NULL);

exec dbms_awrhub.setup_server_cache_mailbox('UWAWRHUB');

UNREGISTER_SOURCE (new 21c)

Unregisters a source from an AWRHub dbms_awrhub.unregister_source( hub_name IN VARCHAR2 DEFAULT NULL, source_name IN VARCHAR2 DEFAULT NULL);

exec dbms_awrhub.unregister_source('UWAWRHUB');