高消耗语句查询

csdn产品小助手

于 2013-10-23 20:17:00 发布

阅读量89

点赞数

CC 4.0 BY-SA版权

文章标签： python

原文链接：https://my.oschina.net/kanlianhui/blog/170863

2019独角兽企业重金招聘Python工程师标准>>>

select substr(sql_text, 1, 120) SQL文本,
       sql_fulltext SQL全文,
       parsing_schema_name 解析用户,
       executions 执行次数,
       disk_reads 磁盘读,
       buffer_gets 内存读,
       round((buffer_gets - disk_reads) / buffer_gets, 2) 缓存命中率,
       round(disk_reads / executions, 2) 单次物理读,
       optimizer_mode 优化器模式
  from v$sqlarea
where executions > 0
   and buffer_gets > 0
   and (buffer_gets - disk_reads) / buffer_gets > 0
   and parsing_schema_name = 'EGISNBUOPR'
order by 7;

转载于:https://my.oschina.net/kanlianhui/blog/170863