Hi Martin,
If we check all parameters with the prefix "_re_":
SQL> @param_ \_re\_
NAME VALUE DEFLT TYPE DESCRIPTION
--------------------------------------- ------ ------ -------
----------------------------------------------------------------
_re_fast_sql_operator all TRUE string enables fast
boxable sql operator
_re_independent_expression_cache_size 20 TRUE number defines max
number of compiled cached expressions for iee
_re_num_complex_operator 1000 TRUE number defines max
number of compiled complex operator per ruleset-iee
_re_num_rowcache_load 2 TRUE number defines max
number of complex operators loaded with row cache
_re_result_cache_keysiz 20 TRUE number defines max
number key for result cache hash table
_re_result_cache_size 20 TRUE number defines max
number of cached elements for result cache
and search them on MOS, we can find these 2 documents:
Doc ID 2524760.1
<https://support.oracle.com/epmos/faces/DocContentDisplay?id=2524760.1> about
"_re_num_complex_operator": ORA-46368 Caused By CREATE AUDIT POLICY With
Many Conditions After Added New Condition
and
Doc ID 31903713.8
<https://support.oracle.com/epmos/faces/DocContentDisplay?id=31903713.8>
about "_re_independent_expression_cache_size": ORA-4025 on
dvf.f$session_user when defining many dv command rules
so it looks like "re" means an internal "rule evaluation" for Unified
Auditing / Database Vault rules.
On Mon, Aug 16, 2021 at 5:38 PM Martin Klier - Performing Databases GmbH <
martin.klier@xxxxxxxxxxxxxxxxx> wrote:
Dear friends of the red Oracle,
what is "Rule Engine's Fast box evaluation"? Can be disabled by
"_re_fast_sql_operator"=disable
What is that box evaluation? Can't find anything useful on the topic
Thanks a lot
Martin
--
Martin Klier // Performing Databases GmbH
Managing Partner // Senior DB Consultant
Oracle ACE Director
martin.klier@xxxxxxxxxxxxxxxxx // https://www.performing-databases.com
