9 Rules Manager Views

Rules Manager defines views containing metadata using the xxx_RLMGR prefix, where xxx can be the string USER or ALL. Rules Manager procedures create and maintain these read-only views.

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. Table 9-2 describes the columns in this view.

Table 9-2 USER_RLMGR_EVENT_STRUCTS View

Column Name	Data Type	Description
`EVENT_STRUCTURE_NAME`	`VARCHAR2`	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. Table 9-3 describes the columns in this view.

Table 9-3 USER_RLMGR_RULE_CLASSES 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 continuous query notifications (formerly database 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. Table 9-4 describes the columns in this view.

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. Table 9-5 describes the columns in this view.

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. Table 9-6 describes the columns in this view.

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