We have an environment with a Gateway 9.3 CR4 and the audit events are externalized for an Oracle RAC.
Although we've tried to reduce the audited events, these tables have a large number of registers and we are thinking about partitioning it.
Is there a recommendation on how to partition the audit tables? We think it's better to partition by date rather than to facilitate a purge but in other applications, this method is not good, because of "hot blocks" and need to be subpartitioned by hash.
API Gateway: 9.3