查看Oracle的redo日志切换频率
来源:互联网 发布:js 强制刷新 编辑:程序博客网 时间:2024/05/20 11:35
转载自:http://blog.itpub.net/12457158/viewspace-721676/
查看Oracle的redo日志切换频率
两个sql,原理是一样的,第二个用到了统计函数。
时间单位:分钟
方法一、
select * from v$log a where a.THREAD# = 1 ;
set line 200
select 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;
select 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 200
select 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;
set line 200
select 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;
0 0
- 查看Oracle的redo日志切换频率
- 查看Oracle的redo日志切换频率
- 查看Oracle的redo日志切换频率
- 查看Oracle的redo日志切换频率
- Oracle redo 日志切换时间频率
- redo 日志切换频率查旬
- oracle 日志切换频率分析
- 【oracle】关于日志产生量的计算-日志切换频率
- ORACLE的redo日志
- 查看日志文件切换频率语句
- 归档日志的切换频率
- Redo logfile切换频率计算
- 统计Redo Log切换频率
- oracle 日志切换频率优化案例
- Oracle Redo生成日志的统计
- oracle 日志切换归档模式查看归档文件的产生
- oracle redo日志恢复
- ORACLE REDO 日志调整
- Gradle详解
- phpstorm快速编辑模板技巧
- 网络编程之对象传递 Serializable接口
- iOS架构设计----1
- Oracle字符替换
- 查看Oracle的redo日志切换频率
- ContentProvider批量导入及事务处理
- HJTextViewPlaceholder
- 202,UIApplication应用程序类
- C随机范围内的数字
- 程序员四门功课
- 算法设计题3.22-栈和队列-第3章-《数据结构习题集》-严蔚敏吴伟民版
- ORACLE-ORA-12154:TNS:could not resolve the connect identifier specified
- unity3d 中IDropHandler 和 IEndDragHandler 优先级别