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 is now availble. If you haven't you downloaded already: Why?

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