Oracle | DBMS_AWR_WAREHOUSE

Oracle DBMS_AWR_WAREHOUSE_SOURCE 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 Utilities used to configure a source database to utilize an AWR Warehouse Database.

AUTHID DEFINER

Dependencies

DBMS_AWRHUB_AGENT	DBMS_LOB	DBMS_WORKLOAD_REPOSITORY
DBMS_AWRHUB_SOURCE	DBMS_STANDARD	PLITBLM
DBMS_AWRWH_LIB	DBMS_UTILITY

Documented No

Exceptions

Error Code	Reason
ORA-13554	`The database is not registered as a AWRHub source`
ORA-13571	AWR import or export operation failed: Unsupported API
ORA-13572	Input parameters to AWRHub operation are invalid: Invalid packaging method input string

First Available 19c

Security Model Owned by SYS with EXECUTE granted to DBA

Source {ORACLE_HOME}/rdbms/admin/dbmsawr.sql

Subprograms

CONFIGURE_SOURCE	NOTIFY_MAILPKG_DELIVERED
GET_MAILPKG_TO_DELIVER	PICKUP_ONE_MAILPKG
LOAD_BLOB_FROM_FILE	REGISTER_AWR_DELIVERY_SERVICE
MODIFY_PACKAGING_METHOD	UNCONFIG_SOURCE

CONFIGURE_SOURCE

Configures the source database to utilize the specified warehouse dbms_awr_warehouse_source.config_source( src_name IN VARCHAR2, warehouse_name IN VARCHAR2, mailbox_loc IN VARCHAR2);

TBD

GET_MAILPKG_TO_DELIVER

Retrieves one mail package (i.e., AWR dump file) that is ready to send to the warehouse dbms_awr_warehouse_source.get_mailpkg_to_deliver( mpkname OUT VARCHAR2, mpkname_l IN NUMBER, mbloc OUT VARCHAR2, mbloc_l IN NUMBER) RETURN BOOLEAN;

TBD

LOAD_BLOB_FROM_FILE (new 23ai)

loads file content into a BLOB dbms_awr_warehouse_source.load_blob_from_file( mbloc IN VARCHAR2, file_name IN VARCHAR2, file_idx IN NUMBER);

TBD

MODIFY_PACKAGING_METHOD (new 23ai)

Enables modifying the packaging method to APS or DATAPUMP dbms_awr_warehouse_source.modify_packaging_method(pkg_method IN VARCHAR2);

exec dbms_awr_warehouse_source.modify_packaging_method('DATAPUMP');

      

      PL/SQL procedure successfully completed.

NOTIFY_MAILPKG_DELIVERED

Invoked at an AWR warehouse client to notify the database that the provided package has successfully delivered to the warehouse dbms_awr_warehouse_source.notify_mailpkg_delivered(mpk_name IN VARCHAR2);

exec dbms_awr_warehouse_source.drop_warehouse('ZZYZX');

      *

      ORA-13565: The database is not registered as a AWRHub source.

PICKUP_ONE_MAILPKG (new 23ai)

Undocumented dbms_awr_warehouse_source.pickup_one_mailpkg( mpkname OUT VARCHAR2, mpkname_l IN NUMBER, num_files OUT 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, file_3_name OUT VARCHAR2, file_3_name_l IN NUMBER, file_3_content OUT BLOB, file_4_name OUT VARCHAR2, file_4_name_l IN NUMBER, file_4_content OUT BLOB, file_5_name OUT VARCHAR2, file_5_name_l IN NUMBER, file_5_content OUT BLOB) RETURN BOOLEAN;

TBD

REGISTER_AWR_DELIVERY_SERVICE

Registers the AWR delivery service for moving an AWR mail package from the source to the warehouse site by RDBMS kernel dbms_awr_warehouse_source.register_awr_delivery_service(server_mailbox IN VARCHAR2);

exec dbms_awr_warehouse_source.register_awr_delivery_service('CLOUD');

      *

      ORA-13571: AWR import or export operation failed: Unsupported API

UNCONFIG_SOURCE

Unconfigures the database as an AWR warehouse source dbms_awr_warehouse_source.unconfig_source;

exec dbms_awr_warehouse_source.unconfig_source;

      *

      ORA-13565: The database is not registered as a AWRHub source.