Oracle DBMS_AWRHUB_SOURCE
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 Source Utilities
AUTHID CURRENT_USER
Constants
Name Data Type Value
General
UPLOAD_BOUND_CURR_SNID VARCHAR2(128) 'CURRENT_SNAP_ID'
UPLOAD_BOUND_MAX_SNID VARCHAR2(128) 'MAX_SNAP_ID'
Dependencies
DBMS_AWRWH_LIB  DBMS_AWR_WAREHOUSE_SERVER  
Documented No
Exceptions
Error Code Reason
ORA-13576 The AWRHub creation operation failed: string
Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);
First Available 20c
Security Model Owned by SYS with EXECUTE granted to the DBA role.
Source {ORACLE_HOME}/rdbms/admin/dbmsawr.sql
Subprograms
 
GET_HUB_ACCOUNT (new 20c)
Returns the hub_account for given source_name and source_id dbms_awrhub_source.get_hub_account(
hub_name    IN VARCHAR2,
source_name IN VARCHAR2,
source_id   IN NUMBER)
RETURN VARCHAR2;
PRAGMA SUPPLEMENTAL_LOG_DATA(GET_HUB_ACCOUNT, READ_ONLY);
TBD
 
MODIFY_SOURCE_SETTINGS (new 20c)
Modifies the settings of an AWR Hub source dbms_awrhub_source.modify_source_settings(
ub_name         IN VARCHAR2,
hub_account     IN VARCHAR2,
upload_interval IN NUMBER DEFAULT NULL);
TBD
 
REGISTER_SOURCE (new 20c)
Configure the database where it runs as an AWRHub source of the specified hub dbms_awrhub_source.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_source.register_source('UW_AWR_HUB', 'PDBTEST', 'AWR_HUB_MAIL');
 
SETUP_SOURCE_CACHE_MAILBOX (new 20c)
Configures a cache mailbox for AWRHub source dbms_awrhub_source.setup_source_cache_mailbox(
hub_name      IN VARCHAR2,
source_name   IN VARCHAR2 DEFAULT NULL,
cache_mailbox IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub_source.setup_source_cache_mailbox('UW_AWR_HUB', 'REMOTE_AWR_SRC', 'AWR_MAIL_HUB');
 
UNREGISTER_SOURCE (new 20c)
Unregisters a source from an AWRHub dbms_awrhub_source.unregister_source(
hub_name    IN VARCHAR2 DEFAULT NULL,
hub_account IN VARCHAR2 DEFAULT NULL);
exec dbms_awrhub_source.unregister_source;

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