AC Database Maintenance

Avatar

Avatar

david_au1

Avatar

david_au1

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)

Avatar

Avatar

florentlb

Avatar

florentlb

florentlb

24-08-2017

Hi,

Please have a look at the following links:

At least part of it should be relevant to your environment.

Let me know if you have specific questions.

Florent.

Answers (1)

Answers (1)

Avatar

Avatar

florentlb

Avatar

florentlb

florentlb

01-09-2017

Hi,

Were you able to go through the links above?

Let me know,

Florent