Re: Thread 1 cannot allocate new log

From: <rsands_at_lendleaserei.com>
Date: Mon, 12 Jun 2000 14:04:22 -0400
Message-Id: <10526.108728@fatcity.com>

--0__=MtaGQB2Xiywqg1CoYnRnbOmbc62ne6CLNzkHerb9UndNV6kuhCVflfTa
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Is it possible to make them too large? (Other than the recovery issue)

Robyn

Chuck Hamilton <chuck_hamilton_at_yahoo.com> on 06/12/2000 01:04:09 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Robyn Sands/US1/Lend Lease)

Subject: Re: Thread 1 cannot allocate new log

 20mb is not all that big. Not only is the archiver having trouble keeping up, but you're also checkpointing at each log switch. I'd start with the logs at 100mb and increase from there if you need to. The only downside is that recovery will take longer, but how often do you have to recover v. how often are you checkpointing?

rsands_at_lendleaserei.com wrote:

Listers,

What's the best approach to deal with the archiver not keeping up with the redo log switches? Currently, redo logs are 20 MB, originally had four groups. We have one process that runs twice a day and results in one or two 'cannot allocate new log' errors. The switch occurs seconds later without causing the update to fail, and the process completes in less than 10 minutes. Tried increasing the size of the logs, no improvement. Added two more log groups, errors stopped for a time, but then reoccurred. This process populates a denormalized table for queries, and the problem began after additional data was added to the base tables. Typically, I see only 4 to 12 switches within a 24 hour period, so I'm not sure if I should continue to added more groups or increase the size. If I increase the size, should I worry about checkpoints occurring too infrequently? (Only occur at log switches now). Both copies of the redo logs and the archived redo logs are all on separate disks.

Robyn

Lend Lease REI
Atlanta, GA

--

Author:
INET: rsands_at_lendleaserei.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists

---

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!

--0__=MtaGQB2Xiywqg1CoYnRnbOmbc62ne6CLNzkHerb9UndNV6kuhCVflfTa
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PFA+IDIwbWIgaXMgbm90IGFsbCB0aGF0IGJpZy4gTm90IG9ubHkgaXMgdGhlIGFyY2hpdmVyIGhh dmluZyB0cm91YmxlIGtlZXBpbmcgdXAsIGJ1dCB5b3UncmUgYWxzbyBjaGVja3BvaW50aW5nIGF0 IGVhY2ggbG9nIHN3aXRjaC4gSSdkIHN0YXJ0IHdpdGggdGhlIGxvZ3MgYXQgMTAwbWIgYW5kIGlu Y3JlYXNlIGZyb20gdGhlcmUgaWYgeW91IG5lZWQgdG8uIFRoZSBvbmx5IGRvd25zaWRlIGlzIHRo YXQgcmVjb3Zlcnkgd2lsbCB0YWtlIGxvbmdlciwgYnV0IGhvdyBvZnRlbiBkbyB5b3UgaGF2ZSB0 byByZWNvdmVyIHYuIGhvdyBvZnRlbiBhcmUgeW91IGNoZWNrcG9pbnRpbmc/PEJSPg0KPFA+IDxC Uj48Qj48ST5yc2FuZHNAbGVuZGxlYXNlcmVpLmNvbTwvST48L0I+IHdyb3RlOiA8QlI+DQo8QkxP Q0tRVU9URSBzdHlsZT0iQk9SREVSLUxFRlQ6ICMxMDEwZmYgMnB4IHNvbGlkOyBNQVJHSU4tTEVG VDogNXB4OyBQQURESU5HLUxFRlQ6IDVweCI+PEJSPjxCUj48QlI+TGlzdGVycyw8QlI+PEJSPldo YXQncyB0aGUgYmVzdCBhcHByb2FjaCB0byBkZWFsIHdpdGggdGhlIGFyY2hpdmVyIG5vdCBrZWVw aW5nIHVwIHdpdGggdGhlIHJlZG88QlI+bG9nIHN3aXRjaGVzPyBDdXJyZW50bHksIHJlZG8gbG9n cyBhcmUgMjAgTUIsIG9yaWdpbmFsbHkgaGFkIGZvdXIgZ3JvdXBzLiBXZTxCUj5oYXZlIG9uZSBw cm9jZXNzIHRoYXQgcnVucyB0d2ljZSBhIGRheSBhbmQgcmVzdWx0cyBpbiBvbmUgb3IgdHdvICdj YW5ub3Q8QlI+YWxsb2NhdGUgbmV3IGxvZycgZXJyb3JzLiBUaGUgc3dpdGNoIG9jY3VycyBzZWNv bmRzIGxhdGVyIHdpdGhvdXQgY2F1c2luZyB0aGU8QlI+dXBkYXRlIHRvIGZhaWwsIGFuZCB0aGUg cHJvY2VzcyBjb21wbGV0ZXMgaW4gbGVzcyB0aGFuIDEwIG1pbnV0ZXMuIFRyaWVkPEJSPmluY3Jl YXNpbmcgdGhlIHNpemUgb2YgdGhlIGxvZ3MsIG5vIGltcHJvdmVtZW50LiBBZGRlZCB0d28gbW9y ZSBsb2cgZ3JvdXBzLDxCUj5lcnJvcnMgc3RvcHBlZCBmb3IgYSB0aW1lLCBidXQgdGhlbiByZW9j Y3VycmVkLiBUaGlzIHByb2Nlc3MgcG9wdWxhdGVzIGE8QlI+ZGVub3JtYWxpemVkIHRhYmxlIGZv ciBxdWVyaWVzLCBhbmQgdGhlIHByb2JsZW0gYmVnYW4gYWZ0ZXIgYWRkaXRpb25hbCBkYXRhIHdh czxCUj5hZGRlZCB0byB0aGUgYmFzZSB0YWJsZXMuIFR5cGljYWxseSwgSSBzZWUgb25seSA0IHRv IDEyIHN3aXRjaGVzIHdpdGhpbiBhIDI0PEJSPmhvdXIgcGVyaW9kLCBzbyBJJ20gbm90IHN1cmUg aWYgSSBzaG91bGQgY29udGludWUgdG8gYWRkZWQgbW9yZSBncm91cHMgb3I8QlI+aW5jcmVhc2Ug dGhlIHNpemUuIElmIEkgaW5jcmVhc2UgdGhlIHNpemUsIHNob3VsZCBJIHdvcnJ5IGFib3V0IGNo ZWNrcG9pbnRzPEJSPm9jY3VyIQ0KIQ0KcmluZyB0b28gaW5mcmVxdWVudGx5PyAoT25seSBvY2N1 ciBhdCBsb2cgc3dpdGNoZXMgbm93KS4gQm90aCBjb3BpZXMgb2Y8QlI+dGhlIHJlZG8gbG9ncyBh bmQgdGhlIGFyY2hpdmVkIHJlZG8gbG9ncyBhcmUgYWxsIG9uIHNlcGFyYXRlIGRpc2tzLjxCUj48 QlI+Um9ieW48QlI+PEJSPkxlbmQgTGVhc2UgUkVJPEJSPkF0bGFudGEsIEdBPEJSPjxCUj48QlI+ LS0gPEJSPkF1dGhvcjogPEJSPklORVQ6IHJzYW5kc0BsZW5kbGVhc2VyZWkuY29tPEJSPjxCUj5G YXQgQ2l0eSBOZXR3b3JrIFNlcnZpY2VzIC0tICg4NTgpIDUzOC01MDUxIEZBWDogKDg1OCkgNTM4 LTUwNTE8QlI+U2FuIERpZWdvLCBDYWxpZm9ybmlhIC0tIFB1YmxpYyBJbnRlcm5ldCBhY2Nlc3Mg LyBNYWlsaW5nIExpc3RzPEJSPi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPEJSPlRvIFJFTU9WRSB5b3Vyc2VsZiBmcm9t IHRoaXMgbWFpbGluZyBsaXN0LCBzZW5kIGFuIEUtTWFpbCBtZXNzYWdlPEJSPnRvOiBMaXN0R3Vy dUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBzcGVsbGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW48 QlI+dGhlIG1lc3NhZ2UgQk9EWSwgaW5jbHVkZSBhIGxpbmUgY29udGFpbmluZzogVU5TVUIgT1JB Q0xFLUw8QlI+KG9yIHRoZSBuYW1lIG9mIG1haWxpbmcgbGlzdCB5b3Ugd2FudCB0byBiZSByZW1v dmVkIGZyb20pLiBZb3UgbWF5PEJSPmFsc28gc2VuZCB0aGUgSEVMUCBjb21tYW5kIGZvciBvdGhl ciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3JpYmluZykuIDxCUj48L0JMT0NLUVVPVEU+PEJSPjxw Pjxicj48aHIgc2l6ZT0xPjxiPkRvIFlvdSBZYWhvbyE/PC9iPjxicj4NCjxhIGhyZWY9Imh0dHA6 Ly9waG90b3MueWFob28uY29tLyI+WWFob28hIFBob3RvczwvYT4gLS0gbm93LCAxMDAgRlJFRSBw Received on Mon Jun 12 2000 - 13:04:22 CDT