Purging from aud$
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Tue, 13 Jul 2021 15:57:49 +0100
Message-ID: <CAGtsp8nJJGh45o+_cSG3kMgKX+tux1P5j11ExbXQwEzdG9zNeQ_at_mail.gmail.com>
Has anyone seen this behaviour before (reported against 19.7 on the MOSC database administrator forum).
Date: Tue, 13 Jul 2021 15:57:49 +0100
Message-ID: <CAGtsp8nJJGh45o+_cSG3kMgKX+tux1P5j11ExbXQwEzdG9zNeQ_at_mail.gmail.com>
Has anyone seen this behaviour before (reported against 19.7 on the MOSC database administrator forum).
You set the db_delete_batch_size to N through the dbms_audit_mgmt package and Oracle is supposed to generate a delete statement that includes the predicate "rownum <= N". Instead of using N, however, it uses a value which is in the order of 0x7FFn00000000 + N
It seems to be a problem that appears in the library dbms_audit_mgmt_li, or as the correct value is passed to a procedure in that library.
Regards
Jonathan Lewis
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 13 2021 - 16:57:49 CEST