日志文件大小问题解决方案报告
整体解决分两步走
目前修改建议:增大日志文件,同时增加日志组个数。
争取能达到业务高峰期 3-5 分钟切换一次。平均 15-20 分钟切一次。
第一步:
SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select * from (select b.recid,b.first_time,a.first_time
last_time,round((a.first_time-b.first_time)*24*60,2) minates
from v$log_history a,v$log_history b
where a.recid=b.recid +1
order by a.first_time desc) where rownum<120
RECID FIRST_TIME LAST_TIME MINATES
11572 2010/11/8 20:44:20 2010/11/8 21:04:18 19.97
11571 2010/11/8 20:43:16 2010/11/8 20:44:20 1.07
11570 2010/11/8 18:47:18 2010/11/8 20:43:16 115.97
11569 2010/11/8 17:03:01 2010/11/8 18:47:18 104.28
11568 2010/11/8 16:59:12 2010/11/8 17:03:01 3.82
11567 2010/11/8 16:26:43 2010/11/8 16:59:12 32.48
11566 2010/11/8 15:39:18 2010/11/8 16:26:43 47.42
11565 2010/11/8 15:09:37 2010/11/8 15:39:18 29.68
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
11564 2010/11/8 15:06:07 2010/11/8 15:09:37 3.5
11563 2010/11/8 15:05:55 2010/11/8 15:06:07 0.2
11562 2010/11/8 15:05:41 2010/11/8 15:05:55 0.23
11561 2010/11/8 15:05:28 2010/11/8 15:05:41 0.22
11560 2010/11/8 15:03:59 2010/11/8 15:05:28 1.48
11559 2010/11/8 14:52:44 2010/11/8 15:03:59 11.25
11558 2010/11/8 14:35:27 2010/11/8 14:52:44 17.28
11557 2010/11/8 14:21:47 2010/11/8 14:35:27 13.67
11556 2010/11/8 14:10:30 2010/11/8 14:21:47 11.28
11555 2010/11/8 14:00:58 2010/11/8 14:10:30 9.53
11554 2010/11/8 13:53:08 2010/11/8 14:00:58 7.83
11553 2010/11/8 13:26:04 2010/11/8 13:53:08 27.07
11552 2010/11/8 12:01:15 2010/11/8 13:26:04 84.82
11551 2010/11/8 11:23:40 2010/11/8 12:01:15 37.58
11550 2010/11/8 11:07:02 2010/11/8 11:23:40 16.63
#NO1 第一段 5 分钟切换次数 5 次 250M
11549 2010/11/8 11:06:20 2010/11/8 11:07:02 0.7
11548 2010/11/8 11:05:29 2010/11/8 11:06:20 0.85