We have just migrated to DLP 14.6 Oracle Standard Edition. On the previous version we were facing space issues, once deleting incidents didn’t free up space in their Oracle database.
I’ve seen DLP 14.6 has a new utility that can be run to reclaim space in their Oracle database, however, in my opinion it’s just workaround option to make the space when the issue occur. What I’m looking for is alternative to really prevent this issue.
I’ve discussed with DBAs and have heard two options to avoid this trap: Segregate table space for BLOB and VARCHAR2 Datatype utilization, which doesn’t fill blanc spaces. Both could reduce database fragmentation.
I was wondering if anyone has any experience with this change or any further information on it.