Oracle DBMS_AWRHUB

Oracle DBMS_AWRHUB_SERVER Version 20c

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

AUTHID CURRENT_USER

Dependencies

DBMS_AWRHUB_SOURCE

DBMS_AWRWH_LIB

DBMS_AWR_WAREHOUSE_SOURCE

Documented No

Exceptions

Error Code	Reason
ORA-13576	The AWRHub creation operation failed: string

First Available 20c

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to the DBA role.

Source {ORACLE_HOME}/rdbms/admin/dbmsawr.sql

Subprograms

CREATE_HUB	MODIFY_SERVER_SETTINGS	SETUP_SERVER_CACHE_MAILBOX
DROP_HUB

CREATE_HUB (new 20c)

Designate the database it runs on as an AWRHub that will store AWR data uploaded by its sources dbms_awrhub_server.create_hub( 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_server.drop_hub('UWAWRHUB', 'AWR_HUB_MAIL');

DROP_HUB (new 20c)

Drops the hub previously created at the database dbms_awrhub_server.drop_hub(hub_name IN VARCHAR2 DEFAULT NULL);

exec dbms_awrhub_server.drop_hub('UWAWRHUB');

MODIFY_SERVER_SETTINGS (new 20c)

Modifies the server settings dbms_awrhub_server.modify_server_settings( hub_name IN VARCHAR2, download_interval IN NUMBER DEFAULT NULL);

exec dbms_awrhub_server.modify_server_settings('UWAWRHUB', 2);

SETUP_SERVER_CACHE_MAILBOX (new 20c)

Sets up a cache mailbox for AWRHub server dbms_awrhub_server.setup_server_cache_mailbox( hub_name IN VARCHAR2, cache_mailbox IN VARCHAR2 DEFAULT NULL);

exec dbms_awrhub_server.setup_server_cache_mailbox('UWAWRHUB', 'AWR_MAIL_HUB');