Re: sizing redo logs

First you need to create new redo logs with size 4M. alter database add logfile 'file_name' size 4M;

Then switch to new redo logs:
alter system switch logfile;

Check what redo is log currently active: select * from v$logfile;

Finally delete old redo logs:
alter database drop logfile 'file_name';

And don't forget to delete redo log files from file system.

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.
Received on Tue Nov 21 2000 - 04:41:26 CST