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

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

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

2、bwherea.recid=b.recid+1orderbya.firsdesc)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.281156

3、82010/11/816:59:122010/11/817:03:013.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

4、/11/815:06:070.2115622010/11/815:05:412010/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:3

5、5:2713.67115562010/11/814:10:302010/11/814:21:4711.28115552010/11/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

6、.58115502010/11/811:07:022010/11/811:23:4016.63#NO1第一段5分钟切换次数5次250M115492010/11/811:06:202010/11/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/

7、811:04:020.77####################################################115442010/11/811:01:442010/11/811:03:161.53115432010/11/811: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/8

8、10:51:5417.62115392010/11/810:0&002010/11/810:34:1726.28115382010/11/89:50:532010/11/810:08:0017.12115372010/11/89:37:232010