Oracle DBMS_AWRHUB
Version 21c

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

Procedures cannot be replicated by LogMiner via regular DML/DDL apply (replication of SYS schema is not supported) nor using 'Procedural replication' (re-invoking the procedure at the logical standby produce different results).
AUTHID CURRENT_USER
Dependencies
DBMS_AWRHUB_SERVER DBMS_AWRHUB_SOURCE DBMS_REPLAYHUB
Documented No
Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);
First Available 21c
Security Model Owned by SYS with EXECUTE granted to the DBA role.
Source {ORACLE_HOME}/rdbms/admin/dbmsawr.sql
Subprograms
CREATE_SERVER REGISTER_SOURCE SETUP_SOURCE_CACHE_MAILBOX
DROP_SERVER SETUP_SERVER_CACHE_MAILBOX UNREGISTER_SOURCE
 
CREATE_SERVER (new 21c)
Designates the database it runs on as an AWRHub server that will store AWR data uploaded by its sources dbms_awrhub.create_server(
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.create_server('UWAWRHUB', 'AWR_HUB_MAIL');
 
DROP_SERVER (new 21c)
Drops the previously created server dbms_awrhub.drop_server(hub_name IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub.drop_server('UWAWRHUB');
 
REGISTER_SOURCE (new 21c)
Configures the database where it runs as an AWRHub source of the specified hub dbms_awrhub.register_source(
hub_name     IN VARCHAR2,
source_name  IN VARCHAR2 DEFAULT NULL,
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.register_source('UWAWRHUB', NULL, 'AWR_HUB_MAIL');
 
SETUP_SERVER_CACHE_MAILBOX (new 21c)
Setups up a cache mailbox for AWRHub source. A source cache mailbox is a temporary location for mailpkgs to be put in before exported to the hub mailbox. dbms_awrhub.setup_source_cache_mailbox(
hub_name      IN VARCHAR2,
source_name   IN VARCHAR2 DEFAULT NULL,
cache_mailbox IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub.setup_source_cache_mailbox('UWAWRHUB');
 
SETUP_SOURCE_CACHE_MAILBOX (new 21c)
Setups a cache mailbox for AWRHub source. A source cache mailbox is a temporary location for mailpkgs to be put in beforeexported to the hub mailbox dbms_awrhub.setup_server_cache_mailbox(
hub_name      IN VARCHAR2,
cache_mailbox IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub.setup_server_cache_mailbox('UWAWRHUB');
 
UNREGISTER_SOURCE (new 21c)
Unregisters a source from an AWRHub dbms_awrhub.unregister_source(
hub_name    IN VARCHAR2 DEFAULT NULL,
source_name IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub.unregister_source('UWAWRHUB');

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_AWRHUB_SERVER
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