performance of backup degrade continuously

Joe, while you point about the amount of data being limited by purge/delete process the backup time while related to the amount of data is more closely related to the size of the file system being backed up rather than the amount of data itself.

This means that even though you have basically limited the total number of rows of data that you have that depending on how the tables/indexes and tablespace themselves were configured the physical database could continue to grow until the objects reach a more or less steady state. You should check on the pctfree, pctused, extent allocation etc... to be sure everything was setup for efficient space reuse.

Also on UNIX and perhaps other OS's it is possible to configure the system so that jobs that run a long time drop to a lower run priority after a certain amount of time. This keeps more resources available to online and high priority applications. You should check with your system administrator about if NICE or equilivent is configured to do this.

HTH -- Mark D Powell --

PS Google appears to be acting up having failed to fill in the subject line so if this post looks like a response without a prior post you know why. Received on Sat Jun 24 2006 - 15:44:27 CDT