OTM 5.5: Safe to purge OBJECT_LOCK, BN_SEQUENCE and S_EQUIPMENT tables?

[ianlo]

Hi everyone,

After running OTM for about 1 year and also running the data purging processes fastidiously, I have noticed that the following tables are not being 'cleaned' up properly after the SHIPMENT, ORDER RELEASE and ORDER BASE records have been archived:

1) OBJECT_LOCK
2) BN_SEQUENCE
3) S_EQUIPMENT

These tables are frequently accessed by OTM and I based on my query profiling, they may be the cause of my performance issue.

I would like to kindly check if anyone knows if these tables can be surgically purged safely?

Thanks for any replies!
Ian