oracle日志切换频率多大,Oracle工作总结——日志文件切换频率的调整

日志文件大小问题解决方案报告

整体解决分两步走

目前修改建议：增大日志文件，同时增加日志组个数。

争取能达到业务高峰期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