《（工作总结）Oracle工作总结——日志文件切换频率的调整》由会员分享，可在线阅读，更多相关《（工作总结）Oracle工作总结——日志文件切换频率的调整（7页珍藏版）》请在金锄头文库上搜索。
1、日志文件大小问题解决方案报告整体解决分两步走目前修改建议：增大日志文件，同时增加日志组个数。争取能达到业务高峰期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 whe
2、re a.recid=b.recid +1 order by a.first_time desc) where rownum115642010/11/8 15:06:072010/11/8 15:09:373.5115632010/11/8 15:05:552010/11/8 15:06:070.2115622010/11/8 15:05:412010/11/8 15:05:550.23115612010/11/8 15:05:282010/11/8 15:05:410.22115602010/11/8 15:03:592010/11/8 15:05:281.48115592010/11/8
3、14:52:442010/11/8 15:03:5911.25115582010/11/8 14:35:272010/11/8 14:52:4417.28115572010/11/8 14:21:472010/11/8 14:35:2713.67115562010/11/8 14:10:302010/11/8 14:21:4711.28115552010/11/8 14:00:582010/11/8 14:10:309.53115542010/11/8 13:53:082010/11/8 14:00:587.83115532010/11/8 13:26:042010/11/8 13:53:08
4、27.07115522010/11/8 12:01:152010/11/8 13:26:0484.82115512010/11/8 11:23:402010/11/8 12:01:1537.58115502010/11/8 11:07:022010/11/8 11:23:4016.63#NO1 第一段 5分钟切换次数 5次 250M115492010/11/8 11:06:202010/11/8 11:07:020.7115482010/11/8 11:05:292010/11/8 11:06:200.85115472010/11/8 11:04:462010/11/8 11:05:290.7
5、2115462010/11/8 11:04:022010/11/8 11:04:460.73115452010/11/8 11:03:162010/11/8 11:04:020.77#115442010/11/8 11:01:442010/11/8 11:03:161.53115432010/11/8 11:00:492010/11/8 11:01:440.92115422010/11/8 10:58:282010/11/8 11:00:492.35115412010/11/8 10:51:542010/11/8 10:58:286.57115402010/11/8 10:34:172010/
6、11/8 10:51:5417.62115392010/11/8 10:08:002010/11/8 10:34:1726.28115382010/11/8 9:50:532010/11/8 10:08:0017.12115372010/11/8 9:37:232010/11/8 9:50:5313.5115362010/11/8 9:27:482010/11/8 9:37:239.58115352010/11/8 9:14:022010/11/8 9:27:4813.77115342010/11/8 8:50:342010/11/8 9:14:0223.47115332010/11/8 8:
7、15:572010/11/8 8:50:3434.62115322010/11/8 7:28:492010/11/8 8:15:5747.13115312010/11/8 7:28:422010/11/8 7:28:490.12115302010/11/8 4:30:512010/11/8 7:28:42177.85115292010/11/8 1:56:312010/11/8 4:30:51154.33115282010/11/7 22:14:142010/11/8 1:56:31222.28115272010/11/7 18:21:212010/11/7 22:14:14232.88115
8、262010/11/7 16:05:222010/11/7 18:21:21135.98115252010/11/7 14:32:282010/11/7 16:05:2292.9115242010/11/7 13:47:082010/11/7 14:32:2845.33 段落2# NO2 这一段最为频繁 开始时间 13:47:08 截止时间 13:42分#切换次数 12次 600M 115232010/11/7 13:46:112010/11/7 13:47:080.95115222010/11/7 13:45:382010/11/7 13:46:110.55115212010/11/7 13
9、:45:112010/11/7 13:45:380.45115202010/11/7 13:44:382010/11/7 13:45:110.55115192010/11/7 13:44:162010/11/7 13:44:380.37115182010/11/7 13:43:562010/11/7 13:44:160.33115172010/11/7 13:43:342010/11/7 13:43:560.37115162010/11/7 13:43:132010/11/7 13:43:340.35115152010/11/7 13:42:522010/11/7 13:43:130.3511
10、5142010/11/7 13:42:312010/11/7 13:42:520.35115132010/11/7 13:42:072010/11/7 13:42:310.4115122010/11/7 13:41:432010/11/7 13:42:070.4#NO 3开始时间 13:41:43 截止时间 13:36分#切换次数 11次 550M115112010/11/7 13:41:192010/11/7 13:41:430.4115102010/11/7 13:40:582010/11/7 13:41:190.35115092010/11/7 13:40:342010/11/7 13:
11、40:580.4115082010/11/7 13:40:012010/11/7 13:40:340.55115072010/11/7 13:39:252010/11/7 13:40:010.6115062010/11/7 13:38:342010/11/7 13:39:250.85115052010/11/7 13:38:012010/11/7 13:38:340.55115042010/11/7 13:37:072010/11/7 13:38:010.9115032010/11/7 13:36:372010/11/7 13:37:070.5115022010/11/7 13:35:4220
12、10/11/7 13:36:370.92115012010/11/7 13:34:542010/11/7 13:35:420.8# NO 3开始时间 13:34:54 截止时间 13:29分#切换次数 9次 450M115002010/11/7 13:34:062010/11/7 13:34:540.8114992010/11/7 13:33:072010/11/7 13:34:060.98114982010/11/7 13:32:362010/11/7 13:33:070.52114972010/11/7 13:32:122010/11/7 13:32:360.4114962010/11/7 13:31:422010/11/7 13:32:120.5114952010/11/7 13:30:512010/11/7 13:31:420.85114942010/11/7 13:30:122010/11/7 13:30:510.65114932010/11/7 13:29:122010/11/7
