Oracle DBMS_AWRHUB

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	REGISTER_SOURCE	UNREGISTER_SOURCE
MODIFY_SOURCE_SETTINGS	SETUP_SOURCE_CACHE_MAILBOX

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;