Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sizing redo logs
You cannot resize, but you can add and drop logfiles as long as they're not online, don't need archiving, or would put the total number of redo log groups below 2. You can resize your logs by adding new correctly sized logfiles, cycling through your redo until the smaller logs aren't online or need archiving and drop the old ones.
In article <8vc469$rg$1_at_nnrp1.deja.com>,
sboucher_at_my-deja.com wrote:
> Can I change the size of the online redo logs. Whoever set-up the
> database has these sized at 1,024K. I want to change to about 4,096k
> or larger to reduce the number of archive operations.
>
> We are running version 8.05 ( I know this is a dinosaur!!). Any help
> greatly appreciated.
>
> Thanks
> Scott
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 20 2000 - 16:08:03 CST