Oracle | DBMS_AWR_WAREHOUSE

Oracle DBMS_AWR_WAREHOUSE_SERVER Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Utilities used to configure an AWR Warehouse Database.

AUTHID DEFINER

Dependencies

DBMS_AWRHUB_SERVER

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

CREATE_WAREHOUSE	GET_UPLOAD_MAILBOX_PATH	REGISTER_DBID
DROP_WAREHOUSE	NOTIFY_WH_MAILPKG_ARRIVED	UNREGISTER_DBID

CREATE_WAREHOUSE

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

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

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

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

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

Unregister DBID that was previously registered into the warehouse dbms_awr_warehouse_server.unregister_dbid( client_name IN VARCHAR2, src_dbid IN NUMBER);

TBD