Oracle 调整重做日志(redo)大小

Oracle 调整重做日志(redo)大小

/*Oracle 调整重做日志(redo)大小需求描述：Oracle 默认3个50M的redo日志，对于大量TPS的系统，会出现频繁的日志切换，影响系统性能；解决办法：新增3个redo日志，并将日志大小调整为为1G；遗留问题：修改原有redo日志时，会出现无法删除的问题，需要等待日志切换时，在尝试。*/-- 查看redo日志select * from v$logfile;select (a.bytes/ 1024/1024) as size_m, a.* from v$log a order by first_time;-- 修订redo日志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;