Oracle DBMS_AWRHUB_SERVER
Version 20c

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 AWR Server Host Utilities
AUTHID CURRENT_USER
Dependencies
DBMS_AWRHUB_SOURCE DBMS_AWRWH_LIB DBMS_AWR_WAREHOUSE_SOURCE
Documented No
Exceptions
Error Code Reason
ORA-13576 The AWRHub creation operation failed: string
First Available 20c
Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);
Security Model Owned by SYS with EXECUTE granted to the DBA role.
Source {ORACLE_HOME}/rdbms/admin/dbmsawr.sql
Subprograms
 
CREATE_HUB (new 20c)
Designate the database it runs on as an AWRHub that will store AWR data uploaded by its sources dbms_awrhub_server.create_hub(
hub_name     IN VARCHAR2,
hub_mailbox  IN VARCHAR2,
mailbox_type IN VARCHAR2 DEFAULT 'FILE_SYSTEM',
mailbox_cred IN VARCHAR2 DEFAULT NULL,
cred_owner   IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub_server.drop_hub('UWAWRHUB', 'AWR_HUB_MAIL');
 
DROP_HUB (new 20c)
Drops the hub previously created at the database dbms_awrhub_server.drop_hub(hub_name IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub_server.drop_hub('UWAWRHUB');
 
MODIFY_SERVER_SETTINGS (new 20c)
Modifies the server settings dbms_awrhub_server.modify_server_settings(
hub_name          IN VARCHAR2,
download_interval IN NUMBER    DEFAULT NULL);
exec dbms_awrhub_server.modify_server_settings('UWAWRHUB', 2);
 
SETUP_SERVER_CACHE_MAILBOX (new 20c)
Sets up a cache mailbox for AWRHub server dbms_awrhub_server.setup_server_cache_mailbox(
hub_name      IN VARCHAR2,
cache_mailbox IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub_server.setup_server_cache_mailbox('UWAWRHUB', 'AWR_MAIL_HUB');

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AWRHUB
DBMS_AWRHUB_SOURCE
DBMS_REPLAYHUB
What's New In 19c
What's New In 20c-21c

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