Oracle | DBMS_AWRHUB

Oracle DBMS_AWRHUB_SERVER Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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 23ai)

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 23ai)

Fetch mailpackage from the Hub mailbox and loads them into Server's AWR schema. dbms_awrhub_server.fetch_hub_mailbox;

Deprecated

      

      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 23ai)

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