Oracle 调整重做日志(redo)大小
select * from v$logfile;
select (a.bytes/ 1024/1024) as size_m, a.* from v$log a order by first_time;
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database add logfile group 1 ('d:\DATABASE\db_name\redo01.log') size 1G reuse;
alter database add logfile group 2 ('d:\DATABASE\db_name\redo02.log') size 1G reuse;
alter database add logfile group 3 ('d:\DATABASE\db_name\redo03.log') size 1G reuse;
alter database add logfile group 4 ('d:\DATABASE\db_name\redo04.log') size 1G;
alter database add logfile group 5 ('d:\DATABASE\db_name\redo05.log') size 1G;
alter database add logfile group 6 ('d:\DATABASE\db_name\redo06.log') size 1G;