AC Database Maintenance | Community
Skip to main content
D
david_au1
Level 2
August 24, 2017
Solved

AC Database Maintenance

  • August 24, 2017
  • 2 replies
  • 2516 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by florentlb

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.

2 replies

florentlb
florentlbAccepted solution
Level 10
August 24, 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.

florentlb
florentlb
Level 10
September 1, 2017

Hi,

Were you able to go through the links above?

Let me know,

Florent

Terms & ConditionsAccessibility statement

Loading footer...