API Gateway: Ideal Partitioning for Audit Tables

Products

• CA API Gateway
• API SECURITY
• STARTER PACK-7

Issue/Introduction

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. 

Environment

API Gateway: 9.3

Resolution

We don't have any recommendations for partitioning tables. That is a function outside the scope of the product.