Oracle工作总结——日志文件切换频率的调整.docx

《Oracle工作总结——日志文件切换频率的调整.docx》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、日志文件大小问题解决方案报告整体解决分两步走目前修改建议：增大日志文件，同时增加日志组个数。争取能达到业务高峰期3-5分钟切换一次。平均15-20分钟切一次。第一步：SQL>altersessionsetnls_date_format='yyyy-mm-ddhh24:mi:ss';select*from(selectb.recid,b.first_time,a.first_timelast_time,round((a.first_time-b.first_time)*24*60,2)minatesfromv$log_historya,v$log_historybwherea.recid=

2、b.recid+1orderbya.first_timedesc)whererownum<120RECIDFIRST_TIMELAST_TIMEMINATES115722010/11/820:44:202010/11/821:04:1819.97115712010/11/820:43:162010/11/820:44:201.07115702010/11/818:47:182010/11/820:43:16115.97115692010/11/817:03:012010/11/818:47:18104.28115682010/11/816:59:122010/11/817:03:013.

3、82115672010/11/816:26:432010/11/816:59:1232.48115662010/11/815:39:182010/11/816:26:4347.42115652010/11/815:09:372010/11/815:39:1829.68>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>115642010/11/815:06:072010/11/815:09:373.5115632010/11/815:05:552010/11/815:06:070.2115622010/11/815:05:4

4、12010/11/815:05:550.23115612010/11/815:05:282010/11/815:05:410.22115602010/11/815:03:592010/11/815:05:281.48115592010/11/814:52:442010/11/815:03:5911.25115582010/11/814:35:272010/11/814:52:4417.28115572010/11/814:21:472010/11/814:35:2713.67115562010/11/814:10:302010/11/814:21:4711.28115552010/11/

5、814:00:582010/11/814:10:309.53115542010/11/813:53:082010/11/814:00:587.83115532010/11/813:26:042010/11/813:53:0827.07115522010/11/812:01:152010/11/813:26:0484.82115512010/11/811:23:402010/11/812:01:1537.58115502010/11/811:07:022010/11/811:23:4016.63#NO1第一段5分钟切换次数5次250M115492010/11/811:06:202010/1

6、1/811:07:020.7115482010/11/811:05:292010/11/811:06:200.85115472010/11/811:04:462010/11/811:05:290.72115462010/11/811:04:022010/11/811:04:460.73115452010/11/811:03:162010/11/811:04:020.77####################################################115442010/11/811:01:442010/11/811:03:161.53115432010/11/811

7、:00:492010/11/811:01:440.92115422010/11/810:58:282010/11/811:00:492.35115412010/11/810:51:542010/11/810:58:286.57115402010/11/810:34:172010/11/810:51:5417.62115392010/11/810:08:002010/11/810:34:1726.28115382010/11/89:5