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 will be available on generic Linux platforms in January and soon on AIX and Windows

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