分享更有价值
被信任是一种快乐

如何查看oracle的redo日志组切换频率

文章页正文上

这篇文章主要介绍如何查看oracle的redo日志组切换频率,文中介绍的非常详细,具有一定的参考价值,感兴趣的小伙伴们一定要看完!查看Oracle的redo日志切换频率:单位:分钟第一种:select * from v$log a where a.THREAD# = 1 ;set line 200select b.SEQUENCE#, b.FIRST_TIME,a.SEQUENCE#,a.FIRST_TIME,round(((a.FIRST_TIME-b.FIRST_TIME)*24)*60,2) from v$log_history a, v$log_history b where a.SEQUENCE#=b.SEQUENCE#+1 and b.THREAD#=1 order by a.SEQUENCE# desc;第二种:set line 200select sequence#,first_time,nexttime,round(((first_time-nexttime免费主机域名)*24)*60,2) diff from (select sequence#,first_time,lag(first_time) over(order by sequence#) nexttime from v$log_history where thread#=1) order by sequence# desc;看你的redo日志大小。
Oracle给的建议是一般15-20分钟左右,要根据数据量来判断,最长时间(单位时间内数据量最少)维持在25-30分钟,最好不要超过30分钟。最短时间(单位时间内数据量最大),保持在10分钟以上。SELECT trunc(first_time) “Date”, to_char(first_time, ‘Dy’) “Day”, count(1) “Total”, SUM(decode(to_char(first_time, ‘hh34′),’00’,1,0)) “h0”, SUM(decode(to_char(first_time, ‘hh34′),’01’,1,0)) “h2”, SUM(decode(to_char(first_time, ‘hh34′),’02’,1,0)) “h3”, SUM(decode(to_char(first_time, ‘hh34′),’03’,1,0)) “h4”, SUM(decode(to_char(first_time, ‘hh34′),’04’,1,0)) “h5”, SUM(decode(to_char(first_time, ‘hh34′),’05’,1,0)) “h6”, SUM(decode(to_char(first_time, ‘hh34′),’06’,1,0)) “h7”, SUM(decode(to_char(first_time, ‘hh34′),’07’,1,0)) “h7”, SUM(decode(to_char(first_time, ‘hh34′),’08’,1,0)) “h8”, SUM(decode(to_char(first_time, ‘hh34′),’09’,1,0)) “h9”, SUM(decode(to_char(first_time, ‘hh34′),’10’,1,0)) “h20”, SUM(decode(to_char(first_time, ‘hh34′),’11’,1,0)) “h21”, SUM(decode(to_char(first_time, ‘hh34′),’12’,1,0)) “h22”, SUM(decode(to_char(first_time, ‘hh34′),’13’,1,0)) “h23免费主机域名“, SUM(decode(to_char(first_time, ‘hh34′),’14’,1,0)) “h24”, SUM(decode(to_char(first_time, ‘hh34′),’15’,1,0)) “h25”, SUM(decode(to_char(first_time, ‘hh34′),’16’,1,0)) “h26”, SUM(decode(to_char(first_time, ‘hh34′),’17’,1,0)) “h27”, SUM(decode(to_char(first_time, ‘hh34′),’18’,1,0)) “h28”, SUM(decode(to_char(first_time, ‘hh34′),’19’,1,0)) “h29”, SUM(decode(to_char(first_time, ‘hh34′),’20’,1,0)) “h30”, SUM(decode(to_char(first_time, ‘hh34′),’21’,1,0)) “h31”, SUM(decode(to_char(first_time, ‘hh34′),’22’,1,0)) “h32”, SUM(decode(to_char(first_time, ‘hh34′),’23’,1,0)) “h33″FROM V$log_historygroup by trunc(first_time), to_char(first_time, ‘Dy’)Order by 1以上是“如何查看oracle的redo日志组切换频率”这篇文章的所有内容,感谢各位的阅读!希望分享的内容对大家有帮助,更多相关知识,欢迎关注云技术行业资讯频道!

相关推荐: win7下如何安装mysql5.7.16

这篇文章主要介绍了win7下如何安装mysql5.7.16,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。 1: 下载安装包,解压,添加mysql的bin路径到全局系统变量path中。2:编辑my…

文章页内容下
赞(0) 打赏
版权声明:本站采用知识共享、学习交流,不允许用于商业用途;文章由发布者自行承担一切责任,与本站无关。
文章页正文下
文章页评论上

云服务器、web空间可免费试用

宝塔面板主机、支持php,mysql等,SSL部署;安全高速企业专供99.999%稳定,另有高防主机、不限制内容等类型,具体可咨询QQ:360163164,Tel同微信:18905205712

主机选购导航云服务器试用

登录

找回密码

注册