一次sql性能故障解决

最新推荐文章于 2024-01-02 21:47:52 发布

dbaora

最新推荐文章于 2024-01-02 21:47:52 发布

阅读量1.2w

点赞数

分类专栏： oracle turing 文章标签：性能 sql 索引

本文链接：https://blog.csdn.net/dbaora/article/details/11567491

版权

客户系统出现I/O高和数据库查询慢的问题，通过分析发现一个SQL执行计划异常，进行了全表扫描。通过AWR报告对比，确认该SQL在9号执行正常，10号执行变慢。问题在于该SQL未使用索引。解决方案实施后，性能得到显著改善。

摘要由CSDN通过智能技术生成

客户反映系统I/O资源比较高,并且数据库查询很慢,首先登录到客户环境查看了一下

Sid User Event W Scnds Details
--- ---------- ------------------------------- - ----- -----------------------------
3286SYS        TCP Socket (KGAS)               Y105698                : (0000000000000002)
3243SYSMAN     wait for unread message on bro  Y    29 channel context: (C0000004D119C310)
3304/SYS       DIAG idle wait                  Y    66       component: (0000000000000001)
3177SYS        SQL*Net more data from client   N     0       driver id: (0000000062657100)
3169JTDATA     db file scattered read          Y     0           file#: (0000000000000006) 'jt_data.271.634300641'
3180JTDATA     db file scattered read          Y     0           file#: (000000000000001D) 'jt_dataa101.ora'
3221JTDATA     db file scattered read          Y     0           file#: (000000000000001D) 'jt_dataa101.ora'
3205JTDATA     db file scattered read          Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3220JTDATA     read by other session           Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3234JTDATA     read by other session           Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3246JTDATA     read by other session           Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3255JTDATA     read by other session           Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3267JTDATA     read by other session           Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3271JTDATA     read by other session           Y     0           file#: (0000000000000027) 'jt_dataa_106.ora'
3181JTDATA     db file sequential read         Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3185JTDATA     read by other session           Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3186JTDATA     read by other session           Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3189JTDATA     gc buffer busy                  Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3190JTDATA     db file sequential read         N     0           file#: (000000000000005B) 'jt_data.358.802873621'
3191JTDATA     read by other session           Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3193JTDATA     db file sequential read         Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3196JTDATA     gc buffer busy                  Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3202JTDATA     read by other session           N     0           file#: (000000000000005B) 'jt_data.358.802873621'
3204JTDATA     db file sequential read         Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3219JTDATA     db file sequential read         Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3223JTDATA     read by other session           Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3224JTDATA     db file sequential read         Y     0           file#: (000000000000005B) 'jt_data.358.802873621'
3225JTDATA     db fi

最低0.47元/天解锁文章

dbaora

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
一次sql性能故障解决

客户反映系统I/O资源比较高,并且数据库查询很慢,首先登录到客户环境查看了一下Sid User Event W Scnds Details--- ---------- ------------------------------- - ----- -----------------------------3286SYS TCP Socket (KGAS)
复制链接

扫一扫

专栏目录