SQL Statement Showing Information about
Rule Evaluations
-
total_full_evaluations shows the
number of full evaluations since the Capture process was last
started. Full evaluations are generally expensive, so in
relative terms, a lower number of evaluations is good for
Capture process performance.
-
total_prefilter_discarded shows the
number of events discarded during prefiltering since the Capture
process was last started. The Capture process determined that
these events definitely did not satisfy the Capture process rule
sets during pre-filtering.
-
total_prefilter_kept shows the
number of events kept during pre-filtering since the Capture
process was last started. The Capture process determined that
these events definitely satisfied the Capture process rule sets
during pre-filtering. Such events are converted into LCRs and
enqueued into the Capture process queue.
The following SQL statement shows the
evaluation details:
COL CAPTURE_NAME HEADING 'Capture|Name'
FORMAT A15
COL TOTAL_PREFILTER_DISCARDED HEAD
'Prefilter|Events|Discarded' FORMAT
9999999999
COL TOTAL_PREFILTER_KEPT HEAD
'Prefilter|Events|Kept' FORMAT 9999999
COL TOTAL_PREFILTER_EVALUATIONS HEAD
'Prefilter|Evaluations'
FORMAT 9999999999
COL UNDECIDED HEAD
'Undecided|After|Prefilter' FORMAT 9999999999
COL TOTAL_FULL_EVALUATIONS HEAD
'Full|Evaluations' FORMAT 9999999999
SELECT CAPTURE_NAME,
TOTAL_PREFILTER_DISCARDED,
TOTAL_PREFILTER_KEPT,
TOTAL_PREFILTER_EVALUATIONS,
(TOTAL_PREFILTER_EVALUATIONS -
(TOTAL_PREFILTER_KEPT +
TOTAL_PREFILTER_DISCARDED)) UNDECIDED,
TOTAL_FULL_EVALUATIONS
FROM V$STREAMS_CAPTURE
/
