Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Redo Logs

Redo Logs

From: Vinay Joshi <vjoshi_at_pinnacle.co.uk>
Date: 1998/01/09
Message-ID: <717BDE76D864D011870F00A0C9283F1E0F13BB@exchange.pinnacle.co.uk>#1/1

I have an oracle db which has 3 redo logs 10MB each. Upon investigation, the redo logs are very big in size. Hardly 5% of the redo log size is being used. This causes severe problems when automatic archiving is on. Every time a log switch occurs, the system hiccups (because it is trying to archive the redo log file). Is there a way of decreasing the size of the redo logs. (Perhaps by creating new ones with a smaller size and deleting the old ones).

Any help appreciated.... Received on Fri Jan 09 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US