Oracle DBMS_AWR_WAREHOUSE_SERVER
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 an AWR Warehouse Database.
AUTHID DEFINER
Dependencies
DBMS_AWRWH_LIB    
Documented No
Exceptions
Error Code Reason
   
First Available 19c
Security Model Owned by SYS with EXECUTE granted to DBA
Source {ORACLE_HOME}/rdbms/admin/dbmsawr.sql
Subprograms
 
CREATE_WAREHOUSE (new 19c)
Designate the database it runs on as an AWR warehouse that will store AWR data uploaded by its clients. dbms_awr_warehouse_server.create_warehouse(
warehouse_name IN VARCHAR2,
mailbox_loc    IN VARCHAR2);
TBD
 
DROP_WAREHOUSE (new 19c)
Routine to drop the warehouse previously created at the database dbms_awr_warehouse_server.drop_warehouse;
exec dbms_awr_warehouse_server.drop_warehouse;
 
GET_UPLOAD_MAILBOX_PATH (new 19c)
Returns the OS path to the mailbox where the mail packages from the specified client name and DBID will be uploaded dbms_awr_warehouse_server.get_upload_mailbox_path(
clnname  IN VARCHAR2,
src_dbid IN NUMBER)
RETURN VARCHAR2;
TBD
 
NOTIFY_WH_MAILPKG_ARRIVED? (new 19c)
Notifies the warehouse that a mail package was successfully deposited into the warehouse mailbox dbms_awr_warehouse_server.notify_wh_mailpkg_arrived(
client_name IN VARCHAR2,
src_dbid    IN NUMBER,
mpk_name    IN VARCHAR2);
TBD
 
REGISTER_DBID (new 19c)
Register a DBID whose AWR data will be uploaded into the warehouse dbms_awr_warehouse_server.register_dbid
client_name IN VARCHAR2,
src_dbid    IN NUMBER,
wh_dbid     IN NUMBER DEFAULT NULL);
TBD
 
UNREGISTER_DBID (new 19c)
Unregister DBID that was previously registered into the warehouse dbms_awr_warehouse_server.unregister_dbid(
client_name IN VARCHAR2,
src_dbid    IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_AWR_REPORT_LAYOUT
DBMS_AWR_WAREHOUSE_SOURCE
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