We are using following components.
Database : Oracle 10g ( 10.2.0.1 )
Our DB team is recommending to implement partition strategy for these components, for better management, maintenance and archival.
If you implemented partition strategy on any/all of the above mentioned components, I would like to know.
- What field/column did you use as partition key for each table. I am specifically looking for bizdoc, bizdoccontent and activitylog tables in TN schema. WMPROCESSSTEP table in BPM ( Processaudit and process engine schema)
Can you kindly suggest if you have any recommendations or share the process if you have already implemented.