Oracle | DBMS_SERVER_ALERT

Oracle DBMS_SERVER_ALERT_PRVT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented internal Server Alert support utilities

AUTHID DEFINER

Data Types param_array_t IS VARRAY OF VARCHAR2;

Dependencies

ALERT_TYPE	DBMS_SERVER_ALERT	OBJ$
DBMS_HA_ALERTS_PRVT	DBMS_STREAMS_SM	PLITBLM
DBMS_PROPAGATION_INTERNAL	DBMS_SVRALRT_PRVT_LIB	USER$
DBMS_PRVTAQIP	DBMS_SYS_ERROR	WRI$_ALERT_OUTSTANDING
DBMS_PRVT_TRACE

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthlrt.plb

Subprograms

POST_ALERT

UPDATE_ALERT

POST_ALERT

Undocumented dbms_server_alert_prvt.post_alert( reason_id IN BINARY_INTEGER, same_transaction IN BOOLEAN, raise_warnings IN BOOLEAN, severity_level IN BINARY_INTEGER, object_name IN VARCHAR2, subobject_name IN VARCHAR2, object_owner IN VARCHAR2, object_id IN NUMBER, subobject_id IN NUMBER, reason_parameters IN dbms_server_alert_prvt.param_array_t, action_parameters IN dbms_server_alert_prvt.param_array_t, cleanup_context IN RAW);

TBD

UPDATE_ALERT

Undocumented dbms_server_alert_prvt.post_alert( alert IN sys.alert_type, same_transaction IN BOOLEAN, new_severity_level IN BINARY_INTEGER, raise_warnings IN BOOLEAN);

TBD