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 8-1 lists the names of the views and their descriptions.
View Name | Description |
---|---|
List of all event structures in the current schema |
|
List of all rule classes in the current schema |
|
List of the progress of rule class creation |
|
List of the privileges for the rule class |
|
List of primitive events configured for a rule class and the properties for each event |
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 8-2.
Table 8-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 |
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 8-3.
Table 8-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 rules class is configured for composite events; if so, the value is YES |
SEQUENCE_ENB |
VARCHAR2 |
Indicates whether the rules class is enabled for rule conditions with sequencing; if so, the value is YES |
AUTOCOMMIT |
VARCHAR2 |
Indicates whether the rules 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 |
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 8-4.
The USER_RLMGR_PRIVILEGES
view lists the privileges for the rule classes. This view is defined with the columns listed and described in Table 8-5.
Table 8-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 |
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 8-6.
Table 8-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 |
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 |