用此方法同时能够得到cost最大的语句
--首先抓取snapshot
[db2inst2@localhost ~]$ db2 get snapshot for all on sample > snap.out
--根据执行次数排序
[db2inst2@localhost ~]$ grep -ni "number of executions" snap.out |grep -v "=0" |sort -k 6,6rn
846: Number of executions = 306
1198: Number of executions = 117
1038: Number of executions = 43
654: Number of executions = 43
814: Number of executions = 43
--然后在vi可以根据行数找到具体的sql语句(vi :line#)
Number of executions = 306
Number of compilations = 1
Worst preparation time (ms) = 32
Best preparation time (ms) = 32
Internal rows deleted = Not Collected
Internal rows inserted = Not Collected
Rows read = Not Collected
Internal rows updated = Not Collected
Rows written = Not Collected
Statement sorts = Not Collected
Statement sort overflows = Not Collected
Total sort time = Not Collected
Buffer pool data logical reads = 0
Buffer pool data physical reads = 0
Buffer pool temporary data logical reads = 0
Buffer pool temporary data physical reads = 0
Buffer pool index logical reads = 0
Buffer pool index physical reads = 0
Buffer pool temporary index logical reads = 0
Buffer pool temporary index physical reads = 0
Buffer pool xda logical reads = 0
Buffer pool xda physical reads = 0
Buffer pool temporary xda logical reads = 0
Buffer pool temporary xda physical reads = 0
Total execution time (sec.microsec)= Not Collected
Total user cpu time (sec.microsec) = Not Collected
Total system cpu time (sec.microsec)= Not Collected
Total statistic fabrication time (milliseconds) = Not Collected
Total synchronous runstats time (milliseconds) = Not Collected
Statement text = SELECT CREATE_TIME FROM SYSTOOLS.HMON_ATM_INFO WHERE SCHEMA = ? AND NAME = ? FOR UPDATE
分享到:
相关推荐
查找消耗CPU的SQL 目标:利用DB2 V9的管理视图,分析动态SQL对CPU消耗的技术
DB2监控运行最长、执行次数最多、执行成本最高、准备和预编译时间最长的SQL
db2查看sql执行计划
DB2游标及动态SQL,异常处理,sqlcode,sqlstate
DB2数据库备份还原.SQL 命令 介绍 详细操作说明。
DB2数据库SQL注入手册1
db2常用语句、db2常用语句、db2常用语句、db2常用语句、db2常用语句、db2常用语句、db2常用语句、db2常用语句
从toad里抠出来,用来监控oracle,mysql,db2正在执行的sql,非常简单实用,用来跟踪程序的sql操作,无二选择
从网上找的一些关于DB2存储过程调优的方法和例子,希望对大家有帮助
绝大多数的DBMS都没有提供直观的工具来返回每一条SQL语句的执行时间。 但万能数据库查询分析器却给你提供了这样的便利,它...更多>> 在数据库维护、管理、查询的时候,经常会遇到一次向DBMS提交多条SQL语句的情况。绝...
可远程连接db2,非常方便,参考文档http://blog.csdn.net/zht666/article/details/8781332 的第一步,然后安装此exe连接db2.
DB2 SQL Reference,DB2 SQL参考手册
DB2 SQL 数学函数 DB2 SQL 数学函数 DB2 SQL 数学函数 DB2 SQL 数学函数
sqlserver连接db2数据库,其中需要注意的事项如文档
DB2 SQL 通过函数(CONCAT/POSSTR/LOCATE)实现行转列,列转行 可以按照标点把多列转换为一行,多行转换为一列
db2的sql调试工具-cse工具 db2的sql调试工具-cse工具 db2的sql调试工具-cse工具
IBM DB2SQL信息
DB2存储过程表空间sql专题整理学习
Db2概念、实例、sql介绍、表空间状态、约束、数据移动、应用技巧、操作、sql复制
DB2中常用的SQL语句 经典SQL语句集锦 SQL分类: DDL—数据定义语言(CREATE,ALTER,DROP,DECLARE) DML—数据操纵语言(SELECT,DELETE,UPDATE,INSERT) DCL—数据控制语言(GRANT,REVOKE,COMMIT,ROLLBACK)