Oracle DBMS_AWR_WAREHOUSE_SOURCE
Version 19.3

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_AWRWH_LIB    
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 (new 19c)
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 (new 19c)
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 (new 19c)
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 (new 19c)
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 (new 19c)
Unconfigures the database as an AWR warehouse source dbms_awr_warehouse_source.unconfig_source;
exec dbms_awr_warehouse_source.unconfig_source;

Related Topics
Built-in Functions
Built-in Packages
DBMS_AWR_REPORT_LAYOUT
DBMS_AWR_WAREHOUSE_SERVER
DBMS_WORKLOAD_REPOSITORY
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx