Re: Emergency follow up... Re: Request for comments on upgrade plan

[Wilersh]

On Nov 13, 2007, at 9:38 PM, Stewart Smith wrote:

> On Tue, 2007-11-13 at 11:36 -0500, Wilersh wrote:
>> Could my issues be a result of having to set
>> TimeBetweenLocalCheckpoints really low (5) and NoOfFragmentLogFiles
>> (300) really high during my restore? After the restore I commented
>> those settings out of config.ini and did a rolling restart with --
>> initial on each node. I believe that sets them back to a default
>> setting, which seemed to work for me before.
>
> It'll be the NoOfFragmentLogFiles. 300 is something like 19.2GB of  
> REDO
> log per node. The larger this is, the more changes you can do between
> local checkpoints.
>

Thanks for clearing this up for me Stewart. Every time I think I have  
a fundamental understanding of the cluster stuff, a new wrinkle  
unfolds for me. Ugh.

A quick follow-up, as I continue to re-read the docs, is there a way  
to properly reclaim this disk space, after I've gone back to the  
default settings for these two parameters?

Thanks for your help, now and in the past.

Eric