Huge data in AO_733371_EVENT_PARAMETER has impact on undo space of Oracle DB

The customer is using Oracle DB in production environment. They encountered a problem that Undo space in almost full.

It is identified that the deletion of AO_733371_EVENT_PARAMETER caused this problem.

SQL_ID：7z8pmm0qmhmhf
delete from "AO_733371_EVENT_PARAMETER" where "AO_733371_EVENT_PARAMETER"."EVENT_ID" in (select "AO_733371_EVENT"."ID" from "AO_733371_EVENT" "AO_733371_EVENT" where "AO_733371_EVENT"."CREATED" <= :1 )

It should be due to  too much data written to AO_733371_EVENT_PARAMETER table.

In order to avoid the impact to undo space, the customer wish we can reduce the writing to AO_733371_EVENT_PARAMETER. 

Note

One cause is  below existing issue. Seems the table keeps growing bigger, though batched mail is disabled as mentioned.

• JSWSERVER-20794: Disable populating the database table AO_733371_EVENT_PARAMETER table when Batching feature is disabled

It is better to check any other cause which contribute to too much data in AO_733371_EVENT_PARAMETER.