AC Database Maintenance

david_au1

23-08-2017

We are currently using Adobe 6.1 on Linux and Oracle. The Oracle instance seems to have a larger than expected space requirement.

Adobe Campaign comes with a default archiving policy of 12 months. We are 10 months in had have had to increase disk allocation. With Oracle, the issue is that once a tablespace has reached a level of capacity there must be some active maintenance to reduce the "high water" mark.

As Adobe is a COTS product it would be expected that the DB management would be assisted by the product. This does not appear to be the case with the Oracle implementation. Without this, it would be good to know which objects in the DB need active administration and whether there are any scripts that could be used as the basis for ongoing administration.

Hope that makes sense. Thanks.

Accepted Solutions (1)

Accepted Solutions (1)