Re: Huge generation of archivelog: how to tweak that ?

At Mon, 3 Aug 2009 22:29:39 -0700 (PDT), ca111026 wrote:
>
> Suggestions:
> - Partition the table so instead of purging data you will be able to
> drop partition

This is a good idea but I am not sure our developers will be able to modify their procs before the D-Day.

> - Instead of purging once per month purge every day (or even more
> often)

This could be a good idea providing we had control on it (which we do not).

I will explore the partition idea but I still want to understand why I am in this "chaos".

Thank you. Received on Tue Aug 04 2009 - 00:41:53 CDT