create event monitor pkgcachemon for package cache write to unformatted event ta ble (in userspace1); SET EVENT MONITOR pkgcachemon STATE 1; !sleep 1200 SET EVENT MONITOR pkgcachemon STATE 0; CALL EVMON_FORMAT_UE_TO_TABLES('PKGCACHE', NULL, NULL, NULL, NULL, NULL, NULL, - 1, 'SELECT * FROM pkgcachemon');
SELECT SUM(TOTAL_CPU_TIME) AS TOTAL_CPU_TIME, SUM(STMT_EXEC_TIME) AS STMT_EXEC_TIME, EXECUTABLE_ID, VARCHAR(STMT_TEXT, 1000) AS STMT_TEXT FROM PKGCACHE_EVENT E, PKGCACHE_METRICS M WHERE E.XMLID = M.XMLID GROUP BY EXECUTABLE_ID, VARCHAR(STMT_TEXT, 1000) ;
添加新评论7 条评论
2012-10-05 05:53
2012-10-04 14:19
2012-01-22 01:26
2012-01-19 23:31
2012-01-19 16:41
2012-01-16 23:09
2012-01-16 17:05