Oracle 时段负载情况
ALTER session SET nls_date_format='yyyy-mm-dd hh24:mi:ss';
SELECT *
FROM ( SELECT A.INSTANCE_NUMBER,
A.SNAP_ID,
B.BEGIN_INTERVAL_TIME + 0 BEGIN_TIME,
B.END_INTERVAL_TIME + 0 END_TIME,
ROUND(VALUE - LAG( VALUE, 1 , '0')
OVER(ORDER BY A.INSTANCE_NUMBER, A.SNAP_ID)) "DB TIME"
FROM (SELECT B.SNAP_ID,
INSTANCE_NUMBER,
SUM(VALUE ) / 1000000 / 60 VALUE
FROM DBA_HIST_SYS_TIME_MODEL B
WHERE B.DBID = (SELECT DBID FROM V$DATABASE)
AND UPPER (B.STAT_NAME) IN UPPER(('DB TIME' ))
GROUP BY B.SNAP_ID, INSTANCE_NUMBER) A,
DBA_HIST_SNAPSHOT B
WHERE A.SNAP_ID = B.SNAP_ID
AND B.DBID = (SELECT DBID FROM V$DATABASE)
AND B.INSTANCE_NUMBER = A.INSTANCE_NUMBER)
WHERE TO_CHAR(BEGIN_TIME, 'YYYY-MM-DD') = TO_CHAR(SYSDATE , 'YYYY-MM-DD')
ORDER BY BEGIN_TIME;
本sql会根列出每个时段具体情况
最新文章
- 在线代码编辑器CodeMirror简介
- Swift - @IBDesignable和@IBInspectable
- CSS盒状模型简介
- Java——交通灯
- Jquery实现自动提示下拉框
- com.android.builder.packaging.DuplicateFile
- Jobs定时器 - Quartz
- 多项式相乘(C语言)
- Base64加密解密原理以及代码实现
- 光流和KLT
- centos7使用cobbler(2.8)批量部署操作系统之二
- FilterDispatcher is depredated!plesae use the new filters
- mysql根据某个字符串拆分表中的字段,然后赋值给另外一个字段
- JEECG &; JEESite Tomcat集群 Session共享
- luogu P5234 [JSOI2012]越狱老虎桥
- SAP 生产订单变更管理 OCM Order Changement Management
- cookie和session、
- redmine添加自定义问题状态
- python之路——6
- C#MVC中@HTML中的方法