In the next section, information will be
presented on the rule related views.
Rule and Rule
Set Related Views
Figure 7.5 shows the rule and rule related
views in a single glance. Rules are the key components that
control the flow of the data and the filtering logic. The
description of each of the view follows in the text of this
Figure 7.5 Rule and Rule Set related
This view displays rule statistics. This
view has a row for every rule loaded into shared memory.
Important statistics that can be obtained
from the v$rule view are:
true_hits – This is the number of
times the rule evaluated to TRUE.
maybe_hits – This is the number of
times the rule evaluated to MAYBE.
sql_evaluations – This is the number
of evaluations of the rule that were performed by issuing SQL.
This view displays rule set statistics.
This view has a row for every rule set loaded into shared
memory. This view can be queried to display general information
about rule set evaluations that have occurred since the database
instance last started.