查最近7天的DB Time
来源:互联网 发布:网络节点重要性 编辑:程序博客网 时间:2024/06/05 16:44
WITH sysstat AS
(select sn.begin_interval_time begin_interval_time,
sn.end_interval_time end_interval_time,
ss.stat_name stat_name,
ss.value e_value,
lag(ss.value, 1) over(order by ss.snap_id) b_value
from dba_hist_sysstat ss, dba_hist_snapshot sn
where trunc(sn.begin_interval_time) >= sysdate - 7
and ss.snap_id = sn.snap_id
and ss.dbid = sn.dbid
and ss.instance_number = sn.instance_number
and ss.dbid = (select dbid from v$database)
and ss.instance_number = (select instance_number from v$instance)
and ss.stat_name = 'DB time')
select to_char (BEGIN_INTERVAL_TIME, 'mm-dd hh24:mi') || to_char (END_INTERVAL_TIME, '
hh24:mi') date_time, stat_name, round((e_value - nvl(b_value, 0)) / (extract(day
from(end_interval_time - begin_interval_time)) * 24 * 60 * 60 + extract(hour
from(end_interval_time - begin_interval_time)) * 60 * 60 + extract(minute
from(end_interval_time - begin_interval_time)) * 60 + extract(second
from(end_interval_time - begin_interval_time))), 0) per_sec
from sysstat
where(e_value - nvl(b_value, 0)) > 0 and nvl(b_value, 0) > 0
/
(select sn.begin_interval_time begin_interval_time,
sn.end_interval_time end_interval_time,
ss.stat_name stat_name,
ss.value e_value,
lag(ss.value, 1) over(order by ss.snap_id) b_value
from dba_hist_sysstat ss, dba_hist_snapshot sn
where trunc(sn.begin_interval_time) >= sysdate - 7
and ss.snap_id = sn.snap_id
and ss.dbid = sn.dbid
and ss.instance_number = sn.instance_number
and ss.dbid = (select dbid from v$database)
and ss.instance_number = (select instance_number from v$instance)
and ss.stat_name = 'DB time')
select to_char (BEGIN_INTERVAL_TIME, 'mm-dd hh24:mi') || to_char (END_INTERVAL_TIME, '
hh24:mi') date_time, stat_name, round((e_value - nvl(b_value, 0)) / (extract(day
from(end_interval_time - begin_interval_time)) * 24 * 60 * 60 + extract(hour
from(end_interval_time - begin_interval_time)) * 60 * 60 + extract(minute
from(end_interval_time - begin_interval_time)) * 60 + extract(second
from(end_interval_time - begin_interval_time))), 0) per_sec
from sysstat
where(e_value - nvl(b_value, 0)) > 0 and nvl(b_value, 0) > 0
/
阅读全文
0 0
- 查最近7天的DB Time
- 最近的OGG/DB的推荐补丁
- 最近 关于 Time Managment 的培训 -2013
- DB time VS. DB CPU
- 0.DB-SQLite的增删改查
- db time 时间单位
- Oracle DB Time 解读
- 最近写的DB类,这里留作存档
- AWR report 报告中db time的说明(转)
- oracle查最近一周内的语句
- 查看最近的增删改查操作
- 最近一段time
- db查重复记录
- AWR中的DB Time和CPU time
- Total Call Time与DB Time
- CFML操作DB的添、删、改、查
- 操作DB~~对数据的增删改查!!sql语句
- Oracle DB time概念理解
- windows下安装pip
- Xamarin XAML语言教程使用属性设置进度条的当前进度
- html5第九课时,js表达式
- docker学习笔记08:run命令及参数详解
- 同个html页面多个select根据值选中项
- 查最近7天的DB Time
- Java中反射技术总结
- 基于HTML5 Canvas实现用户交互
- mysql日期函数
- 备忘:PB调用c++ dll
- 微信小程序入门篇(二)
- sklern使用之通用模版(以iris为数据集,knn,PCA)
- ShaderForge插件分享
- iOS最全面试题及答案