Oracle | DBMS_AWRHUB

Oracle DBMS_AWRHUB_AGENT 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 Specification for interfaces that External Agent interact with AWRHub software

AUTHID CURRENT_USER

Dependencies

DBMS_AWR_WAREHOUSE_SERVER	DBMS_WORKLOAD_REPOSITORY
DBMS_AWR_WAREHOUSE_SOURCE

Documented No

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

First Available 23ai

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

Source {ORACLE_HOME}/rdbms/admin/dbmsawragent.sql
{ORACLE_HOME}/rdbms/admin/prvtawragent.sql

Subprograms

CONFIG_SOURCE	PICKUP_ONE_AUTO_GENERATED_MAILPKG
NOTIFY_MAILPKG_DELIVERED	REGISTER_SOURCE_AT_HUB_SERVER

CONFIG_SOURCE (new 23ai)

Configures the database, where it runs, as an AWRHub source of the specified Hub dbms_awrhub_agent.config_source( src_name IN VARCHAR2, hub_name IN VARCHAR2);

TBD

NOTIFY_MAILPKG_DELIVERED (new 23ai)

Invoked at an AWRHub Source to notify the database that the provided package has successfully delivered to the Hub dbms_awrhub_agent.notify_mailpkg_delivered(mpk_name IN VARCHAR2);

TBD

PICKUP_ONE_AUTO_GENERATED_MAILPKG (new 23ai)

Picks up one auto generated mail package dbms_awrhub_agent.pickup_one_auto_generated_mailpkg( mpkname OUT VARCHAR2, mpkname_l IN NUMBER, file_1_name OUT VARCHAR2, file_1_name_l IN NUMBER, file_1_content OUT BLOB, file_2_name OUT VARCHAR2, file_2_name_l IN NUMBER, file_2_content OUT BLOB) RETURN BOOLEAN;

TBD

REGISTER_SOURCE_AT_HUB_SERVER (new 23ai)

Registers a Source Database to a Hub. dbms_awrhub_agent.register_source_at_hub_server( src_name IN VARCHAR2, src_dbid IN NUMBER);

TBD