Oracle | DBMS_AWRHUB

Oracle DBMS_AWRHUB_SERVER Version 23c

General Information

Library Note

Morgan's Library Page Header

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

AUTHID CURRENT_USER

Dependencies

DBMS_AWRHUB

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
{ORACLE_HOME}/rdbms/admin/prvtawr.sql

Subprograms

CREATE_HUB	FETCH_HUB_MAILBOX	PROCESS_REQUESTS
DOWNLOAD_MAILPKG	MODIFY_SERVER_SETTINGS	SETUP_SERVER_CACHE_MAILBOX
DROP_HUB

CREATE_HUB

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

DOWNLOAD_MAILPKG (new 23c)

Downloads the specified mail package into the AWR Schema in the Hub Server dbms_awrhub_server.download_mailpkg( mpk_name IN VARCHAR2, hub_name IN VARCHAR2);

TBD

DROP_HUB

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

FETCH_HUB_MAILBOX (new 23c)

Fetch mailpackage from the Hub mailbox and loads them into Server's AWR schema. This API is deprecated since 23c? dbms_awrhub_server.fetch_hub_mailbox;

exec dbms_awrhub_server.fetch_hub_mailbox;

MODIFY_SERVER_SETTINGS

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

PROCESS_REQUESTS (new 23c)

Process requests deposited in the Hub mailbox dbms_awrhub_server.process_requests;

exec dbms_awrhub_server.process_requests;

SETUP_SERVER_CACHE_MAILBOX

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