Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

AC Database Maintenance

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Level 10

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.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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.

Avatar

Level 10

Hi,

Were you able to go through the links above?

Let me know,

Florent