SELECT MEMBER ,SECTION_TYPE ,VARCHAR( STMT_TEXT ,200) AS STATEMENT ,NUM_EXEC_WITH_METRICS AS NUMEXEC ,TOTAL_CPU_TIME / NUM_EXEC_WITH_METRICS AS AVG_CPU_TIME ,TOTAL_CPU_TIME FROM TABLE(MON_GET_PKG_CACHE_STMT( 'D' ,NULL ,NULL ,-2)) AS T WHERE T.NUM_EXEC_WITH_METRICS <> 0 ORDER BY AVG_CPU_TIME DESC FETCH FIRST 10 ROWS ONLY;
添加新评论0 条评论