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