没有合适的资源?快使用搜索试试~ 我知道了~
Oracle性能查询1.ppt
0 下载量 162 浏览量
2022-11-12
03:15:00
上传
评论
收藏 469KB PPT 举报
温馨提示
试读
17页
Oracle性能查询1.ppt
资源推荐
资源详情
资源评论
Oracle_性能查询
11/12/2022 Oracle性能查询[1]
Top queries by resource usage
Top queries by resource usage
Dimensions
Dimensions
•
•
Resource (CPU time, elapsed time, buffer gets, physical
Resource (CPU time, elapsed time, buffer gets, physical
reads, rows returned)
reads, rows returned)
•
•
Execution (Across all executions, per execution)
Execution (Across all executions, per execution)
•
•
SQL (All SQL, various types of query generator queries,
SQL (All SQL, various types of query generator queries,
inserts, updates, LIKE, …)
inserts, updates, LIKE, …)
11/12/2022 Oracle性能查询[1] 2
按
按
照
照
使
使
用
用
资
资
源
源
列
列
出
出
前
前
100
100
个
个
-- Get the top 100 queries by total number of
-- Get the top 100 queries by total number of
disk_reads_delta
disk_reads_delta
SELECT *
SELECT *
FROM (SELECT SQL_ID,
FROM (SELECT SQL_ID,
SUM(disk_reads_delta) AS "Disk Reads"
SUM(disk_reads_delta) AS "Disk Reads"
FROM DBA_HIST_SQLSTAT S
FROM DBA_HIST_SQLSTAT S
WHERE SNAP_ID > 209
WHERE SNAP_ID > 209
AND SNAP_ID <= 210
AND SNAP_ID <= 210
AND S.MODULE = 'ClaimCenter'
AND S.MODULE = 'ClaimCenter'
GROUP BY SQL_ID
GROUP BY SQL_ID
HAVING SUM(disk_reads_delta) >= 0
HAVING SUM(disk_reads_delta) >= 0
ORDER BY 2 DESC) DERIVED_TABLE
ORDER BY 2 DESC) DERIVED_TABLE
WHERE ROWNUM <= 100;
WHERE ROWNUM <= 100;
11/12/2022 Oracle性能查询[1] 3
按
按
照
照
使
使
用
用
资
资
源
源
列
列
出
出
100
100
个
个
-- Get the top 100 queries by total number of disk_reads_delta by
-- Get the top 100 queries by total number of disk_reads_delta by
execution
execution
SELECT *
SELECT *
FROM (SELECT SQL_ID,
FROM (SELECT SQL_ID,
CASE SUM(EXECUTIONS_DELTA)
CASE SUM(EXECUTIONS_DELTA)
WHEN 0 THEN 0
WHEN 0 THEN 0
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
END AS "Disk Reads/Execution"
END AS "Disk Reads/Execution"
FROM DBA_HIST_SQLSTAT S
FROM DBA_HIST_SQLSTAT S
WHERE SNAP_ID > 209
WHERE SNAP_ID > 209
AND SNAP_ID <= 210
AND SNAP_ID <= 210
AND S.MODULE = 'ClaimCenter'
AND S.MODULE = 'ClaimCenter'
GROUP BY SQL_ID
GROUP BY SQL_ID
HAVING CASE SUM(EXECUTIONS_DELTA)
HAVING CASE SUM(EXECUTIONS_DELTA)
WHEN 0 THEN 0
WHEN 0 THEN 0
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
ELSE SUM(disk_reads_delta) / SUM(EXECUTIONS_DELTA)
END >= 0
END >= 0
ORDER BY 2 DESC) DERIVED_TABLE
ORDER BY 2 DESC) DERIVED_TABLE
WHERE ROWNUM <= 100;
WHERE ROWNUM <= 100;
11/12/2022 Oracle性能查询[1] 4
剩余16页未读,继续阅读
资源评论
智慧安全方案
- 粉丝: 3646
- 资源: 59万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于 SpringCloud 和 Vue3 的OA系统
- 软考高级项目管理师-项目采购管理思维导图
- WordsVector (1).ipynb
- yolov7 车牌检测 车牌识别 中文车牌识别 检测 支持双层车牌 支持12种中文车牌
- 20240429_112025.m4a
- "麦嘟学编程"似乎是一个与编程学习相关的品牌或社区名称,它可能是一个在线教育平台、博客、论坛或社交媒体群组等,旨在帮助人们学习编
- OpenCV(Open Source Computer Vision Library)是一个开源的计算机视觉和机器学习软件库,由
- Redis入门基础篇+源码(springboot、maven)
- ChatGPT-4是由OpenAI开发的人工智能模型,是GPT(Generative Pre-trained Transform
- 91fdd461elb59a4ce8dfcfc46bc283a7.msi
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功