Oracle 18cR3 EVENT

Oracle EVENT Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Captures transient event data for Database Vault

AUTHID DEFINER

Dependencies

DATABASE_NAME	DICTIONARY_OBJ_OWNER	KZV$RUL_LIBT
DBMS_MACSEC_RULES	DICTIONARY_OBJ_TYPE	LOGIN_USER
DICTIONARY_OBJ_NAME	INSTANCE_NUM	SYSEVENT

Documented No

First Available Not Known

Security Model Owned by DVSYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/catmacp.sql

Subprograms

event.set( p_sysevent IN VARCHAR2, p_login_user IN VARCHAR2, p_instance_num IN NUMBER, p_database_name IN VARCHAR2, p_dict_obj_type IN VARCHAR2, p_dict_obj_owner IN VARCHAR2, p_dict_obj_name IN VARCHAR2, P_sql_text IN VARCHAR2); PRAGMA SUPPLEMENTAL_LOG_DATA(set, NONE);

TBD

SETDEFAULT

event.setDefault; PRAGMA SUPPLEMENTAL_LOG_DATA(setdefault, NONE);

exec dvsys.event.setDefault;

SET_C

event.set_c( p_sysevent IN VARCHAR2, p_login_user IN VARCHAR2, p_instance_num IN VARCHAR2, p_database_name IN VARCHAR2, p_dict_obj_type IN VARCHAR2, p_dict_obj_owner IN VARCHAR2, p_dict_obj_name IN VARCHAR2, P_SQL_TEXT IN VARCHAR2); PRAGMA SUPPLEMENTAL_LOG_DATA(set_c, NONE);

TBD