软讯网络 > 冲浪宝典 > 网络资源 > 两个比较有用的捞取性能差的语句 yorking
【标 题】：两个比较有用的捞取性能差的语句 yorking
【关键字】：
yorking
【来 源】：http://www.cublog.cn/u/23246/showart.php?id=174118
两个比较有用的捞取性能差的语句 yorking
两个比较有用的捞取性能差的语句
数据库系统性能存在问题的时候，一般就是在CPU和IO上，特别是IO经常成为系统的瓶颈。
--CPU资源消耗严重的Session
SELECT a.sid,b.spid,a.status,substr(a.program,1,50) program,
a.terminal,osuser,round(value / 60 / 100, 2) value,d.sql_text,
round(d.disk_reads/d.executions,1) "ratio(%)",d.disk_reads,d.executions,d.parse_calls
FROM v＄sqlarea d,v＄session a, v＄process b, v＄sesstat c, v＄statname s
WHERE s.NAME = 'CPU used by this session' AND a.sid = c.sid AND a.paddr = b.addr AND
c.statistic# = s.statistic# AND c.VALUE > 600
AND a.sql_address=d.address
ORDER BY VALUE DESC;
-- 读硬盘多的SQL
SELECT sql_text,round(disk_reads/EXECUTIONS,1) "ratio(%)", disk_reads,PARSE_CALLS,EXECUTIONS
FROM v＄sqlarea
WHERE EXECUTIONS>100
ORDER BY 2 DESC;
SELECT a.sid,b.spid,a.status,SUBSTR(a.program, 1, 40) program,
a.terminal,osuser,ROUND(VALUE / 60 / 100, 2) VALUE
FROM v＄session a, v＄process b, v＄sesstat c, v＄statname s
WHERE s.NAME like 'physical reads%' AND a.sid = c.sid AND a.paddr = b.addr AND
c.statistic# = s.statistic# AND c.VALUE > 600
ORDER BY VALUE DESC;
http://www.blogcn.com/u2/56/59/yorking/index.html?filelist=1&fpage=3#md
【相关文章】
没有相关文章
|