Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

AC Database Maintenance

david_au1
Level 2
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
florentlb
Correct answer by
Level 10
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
florentlb
Correct answer by
Level 10
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

florentlb
Level 10
Level 10

Hi,

Were you able to go through the links above?

Let me know,

Florent