Re: Too much redo! Help!

Here is a possible idea for you: If you are running under UNIX then, are you using the compress utility on the archive files. If not set up a cron job to compress all but the most recent N number of archive files (output of ls -lt command). This can greatly increase the amount of redo you can handle at the cost of having to uncompress before doing a recovery.

From: Tabassam Kayani >>
We have an overnight procedure which creates a large denormalised table by joining a number of existing tables. Unfortunately, more often than not, it fails to complete due to the large amount of redo generated (archived) and running out of disk space as a consequence.

Bearing in mind that we are running under 7.1.6, can someone please suggest how we can keep the redo generated to an absolute minimum ? <<<
Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Wed Jan 06 1999 - 19:41:18 CST