Oracle | DBMS_AWR_WAREHOUSE

Oracle DBMS_AWR_WAREHOUSE_SOURCE Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Utilities used to configure a source database to utilize an AWR Warehouse Database.

AUTHID DEFINER

Dependencies

DBMS_AWRHUB_SOURCE

DBMS_AWRWH_LIB

DBMS_WORKLOAD_REPOSITORY

Documented No

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	UNCONFIG_SOURCE
GET_MAILPKG_TO_DELIVER	REGISTER_AWR_DELIVERY_SERVICE

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

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_server.drop_warehouse;

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

TBD

UNCONFIG_SOURCE

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

exec dbms_awr_warehouse_source.unconfig_source;