Re: Fast box evaluation

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Mon, 16 Aug 2021 19:32:14 +0300
Message-ID: <CAOVevU6FVv0R+2PjLf-YecsxQuYz-HPUikJycELBJU0qhOgyyQ_at_mail.gmail.com>

Hi Martin,

If we check all parameters with the prefix "_re_": SQL> _at_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_at_performing-db.com> 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_at_performing-db.com // https://www.performing-databases.com
>
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 16 2021 - 18:32:14 CEST