根据的提示pengjianjun 修改了一下查找数据库中最耗时的 SQL 语句:SELECT stmt_text, total_exec_time, num_executions FROM TABLE( SNAPSHOT_DYN_SQL('DB_NAME', -1)) as dynSnapTabORDER BY total_exec_time desc FETCH FIRST 1 ROW ONLY平均执行时间最长的五条 SQL 语...
显示全部根据
的提示pengjianjun 修改了一下
查找数据库中最耗时的 SQL 语句:
SELECT stmt_text, total_exec_time, num_executions
FROM TABLE( SNAPSHOT_DYN_SQL('DB_NAME', -1)) as dynSnapTab
ORDER BY total_exec_time desc
FETCH FIRST 1 ROW ONLY
平均执行时间最长的五条 SQL 语句:
SELECT stmt_text,
CASE WHEN num_executions = 0
THEN 0
ELSE (total_exec_time / num_executions)
END avgExecTime,
num_executions
FROM TABLE( SNAPSHOT_DYN_SQL('DB_NAME', -1)) as dynSnapTab
ORDER BY avgExecTime desc
FETCH FIRST 5 ROWS ONLY
[
本帖最后由 heaven_lu 于 2009-6-18 15:18 编辑 ]
收起