Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Redo Logs
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