| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Utilities used to configure an AWR Warehouse Database. |
| AUTHID |
DEFINER |
| Dependencies |
| DBMS_AWRHUB_AGENT |
DBMS_AWRWH_LIB |
DBMS_WORKLOAD_REPOSITORY |
| DBMS_AWRHUB_SERVER |
|
|
|
| Documented |
No |
| First Available |
19c |
| Security Model |
Owned by SYS with EXECUTE granted to DBA |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsawr.sql |
| Subprograms |
|
| |
CLEANUP_ORPHAN_DATAPUMP_TABLES
(new 23ai)  |
| Cleans-up orphan tables created by DataPump |
dbms_awr_warehouse_server.cleanup_orphan_datapump_tables; |
exec dbms_awr_warehouse_server.cleanup_orphan_datapump_tables;
PL/SQL procedure successfully completed. |
| |
| CLEANUP_ORPHAN_IMPEXP_TABLES
(new 23ai) |
| Cleans-up orphan tables created by Export and Import |
dbms_awr_warehouse_server.cleanup_orphan_impexp_tables; |
exec dbms_awr_warehouse_server.cleanup_orphan_impexp_tables;
PL/SQL procedure successfully completed. |
| |
| 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;
PL/SQL procedure successfully completed. |
| |
| 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 |