To speed up queries in the MAP_EVENT table, MVF Task Scheduler moves older audit events to the MAP_EVENT_AUDIT table after a configurable number of days. The CLEAN_MAP_EVENT field in the MVF_TS_CONFIG table specifies how often event records are moved from the MAP_EVENT table to the MAP_EVENT_AUDIT table. By default, records are moved every day at 2:00.
 | Note: To prevent undo/redo logs from growing too quickly, the MAP_EVENT_MAX_ROWS field in the MVF_TS_MODULE_CONFIG table specifies the number of records to process per transaction. The default is 1000. |
To configure when current audit records are moved to the older audit table
To determine the current settings, type
select * from MVF_TS_CONFIG
To configure when audit records are moved from the MAP_EVENT table, type
update MVF_TS_CONFIG set value='minute hour day month weekday' where attribute='CLEAN_MAP_EVENT'
where each of minute hour day month weekday is a numeric value and asterisks are used to represent all. For example, to indicate the default of every day at 2:00, the CLEAN_MAP_EVENT field has the value 0 2 * * *. For hour, 0 represents midnight. For weekday, accepted values are 0–6, and 0 represents Sunday.
After the changes are made, restart MVF Task Scheduler.