9 Rules Manager Views

Rules Manager metadata can be viewed using the Rules Manager views defined with a xxx_RLMGR prefix, where xxx can be the string USER or ALL. These views are read-only to users and are created and maintained by the Rules Manager procedures.

Table 9-1 lists the names of the views and their descriptions.

Table 9-1 Rules Manager Views

View Name	Description
USER_RLMGR_EVENT_STRUCTS View	List of all event structures in the current schema
USER_RLMGR_RULE_CLASSES View	List of all rule classes in the current schema
USER_RLMGR_RULE_CLASS_STATUS View	List of the progress of rule class creation
USER_RLMGR_PRIVILEGES View	List of the privileges for the rule class
USER_RLMGR_COMPRCLS_PROPERTIES View	List of primitive events configured for a rule class and the properties for each event

9.1 USER_RLMGR_EVENT_STRUCTS View

The USER_RLMGR_EVENT_STRUCTS view lists all the event structures in the current schema. This view is defined with the columns listed and described in Table 9-2.

Table 9-2 USER_RLMGR_EVENT_STRUCTS View

Column Name	Data Type	Description
EVENT_STRUCTURE_NAME	VARCHAR2	Specifies the name of the event structure
HAS_TIMESTAMP	VARCHAR2	Specifies whether the event structure has the event creation timestamp - YES/NO
IS_PRIMITIVE	VARCHAR2	Specifies whether the event structure is strictly primitive - YES/NO
TABLE_ALIAS_OF	VARCHAR2	Table name for a table alias primitive event
CONDITIONS_TABLE	VARCHAR2	Name of the table that stores the sharable conditions for this event structure

9.2 USER_RLMGR_RULE_CLASSES View

The USER_RLMGR_RULE_CLASSES view lists all the rule classes in the current schema. This view is defined with the columns listed and described in Table 9-3.

Table 9-3 USER_RLMGR_RULE_CLASS View

Column Name	Data Type	Description
RULE_CLASS_NAME	VARCHAR2	Name of the rule class
ACTION_CALLBACK	VARCHAR2	The procedure configured as the action callback for the rule class
EVENT_STRUCTURE	VARCHAR2	The event structure used for the rule class
RULE_CLASS_PACK	VARCHAR2	Name of the package implementing the rule class cursors (internal)
RCLS_RSLT_VIEW	VARCHAR2	View to display the matching events and rules for the current session
IS_COMPOSITE	VARCHAR2	Indicates whether the rule class is configured for composite events; if so, the value is YES
SEQUENCE_ENB	VARCHAR2	Indicates whether the rule class is enabled for rule conditions with sequencing; if so, the value is YES
AUTOCOMMIT	VARCHAR2	Indicates whether the rule class is configured for auto-committing events and rules; if so, the value is YES
CONSUMPTION	VARCHAR2	Default Consumption policy for the events in the rule class: valid values are EXCLUSIVE and SHARED
DURATION	VARCHAR2	Default Duration policy of the primitive events
ORDERING	VARCHAR2	Ordering clause used for conflict resolution among matching rules and events
EQUAL	VARCHAR2	Equal specification for the rule classes configured for composite events
DML_EVENTS	VARCHAR2	Types of DML operations enabled for event management
CNF_EVENTS	VARCHAR2	Types of Change Notifications enabled for event management

9.3 USER_RLMGR_RULE_CLASS_STATUS View

The USER_RLMGR_RULE_CLASS_STATUS view lists the progress of rule class creation. This view is defined with the columns listed and described in Table 9-4.

Table 9-4 USER_RLMGR_RULE_CLASS_STATUS View

Column Name	Data Type	Description
RULE_CLASS_NAME	VARCHAR2	Name of the rule class
STATUS	VARCHAR2	Current status of the rule class
STATUS_CODE	VARCHAR2	Internal code for the status
NEXT_OPERATION	VARCHAR2	Next operation performed on the rule class

9.4 USER_RLMGR_PRIVILEGES View

The USER_RLMGR_PRIVILEGES view lists the privileges for the rule classes. This view is defined with the columns listed and described in Table 9-5.

Table 9-5 USER_RLMGR_PRIVILEGES View

Column Name	Data Type	Description
RULE_CLASS_OWNER	VARCHAR2	Owner of the rule class
RULE_CLASS_NAME	VARCHAR2	Name of the rule class
GRANTEE	VARCHAR2	Grantee of the privilege. Current user or PUBLIC
PRCS_RULE_PRIV	VARCHAR2	Current user's privilege to execute or process rules
ADD_RULE_PRIV	VARCHAR2	Current user's privilege to add new rules to the rule class
DEL_RULE_PRIV	VARCHAR2	Current user's privilege to delete rules

9.5 USER_RLMGR_COMPRCLS_PROPERTIES View

The USER_RLMGR_COMPRCLS_PROPERTIES view lists the primitive events configured for a rule class and their properties. This view is defined with the columns listed and described in Table 9-6.

Table 9-6 USER_RLMGR_COMPRCLS_PROPERTIES View

Column Name	Data Type	Description
RULE_CLASS_NAME	VARCHAR2	Name of the rule class configured for composite rules
PRIM_EVENT	VARCHAR2	Name of the primitive event in the composite event
PRIM_EVENT_STRUCT	VARCHAR2	Name of the primitive event structure (object type)
HAS_CRTTIME_ATTR	VARCHAR2	Whether the primitive event structure has the `RLM$CRTTIME` attribute; if so, the value is YES
CONSUMPTION	VARCHAR2	Consumption policy for the primitive event: valid values are EXCLUSIVE and SHARED
TABLE_ALIAS_OF	VARCHAR2	Table name for the table alias primitive event
DURATION	VARCHAR2	Duration policy for the primitive event
COLLECTION_ENB	VARCHAR2	Is the primitive event enabled for collections?
GROUPBY_ATTRIBUTES	VARCHAR2	Event attributes that may be used for GROUPBY clauses