互联网服务
关于insert语句的时候CPU过高的问题
各位大侠么，我在测试环境做压力测试的时候发现一条insert语句竟然是CPU里面吃的最高的，我使用 db2pd -database bpedb -edu -applications -dynamic 来获得信息的结果如下下，请问insert语句能造成这样的厉害还是说有别的原因？
Database Partition 0 -- Active -- Up 5 days 07:58:57
List of all EDUs for database partition 0
db2sysc PID: 14090492
db2wdog PID: 26673270
db2acd PID: 30474436
EDU ID TID Kernel TID EDU Name USR SYS
========================================================================================================================================
75408 75408 63701137 db2agent (BPEDB) 0 2897.674917 71.070904
Database Partition 0 -- Database BPEDB -- Active -- Up 4 days 00:17:34
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid WorkloadID WorkloadOccID
0x07800000013C0080 28686 [000-28686] 1 75408 UOW-Waiting 0 0 64 1 132.228.226.20.54504.1303200937 1 2225
Database Partition 0 -- Database BPEDB -- Active -- Up 4 days 00:17:34
Dynamic Cache:
Current Memory Used 63613954
Total Heap Size 63669248
Cache Overflow Flag 0
Number of References 206251322
Number of Statement Inserts 18120
Number of Statement Deletes 12549
Number of Variation Inserts 11585
Number of Statements 5571
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x070000032E3EE6C0 64 1 1 1 2897179 2897179 INSERT INTO
WPRBE00.SCOPE_COMPLETION_COUNTER_T (SIID, PIID, COUNTER, VERSION_ID ) VALUES ( ?, ?, ?, ?)
Database Partition 0 -- Active -- Up 5 days 07:58:57
List of all EDUs for database partition 0
db2sysc PID: 14090492
db2wdog PID: 26673270
db2acd PID: 30474436
EDU ID TID Kernel TID EDU Name USR SYS
========================================================================================================================================
75408 75408 63701137 db2agent (BPEDB) 0 2897.674917 71.070904
Database Partition 0 -- Database BPEDB -- Active -- Up 4 days 00:17:34
Applications:
Address AppHandl [nod-index] NumAgents CoorEDUID Status C-AnchID C-StmtUID L-AnchID L-StmtUID Appid WorkloadID WorkloadOccID
0x07800000013C0080 28686 [000-28686] 1 75408 UOW-Waiting 0 0 64 1 132.228.226.20.54504.1303200937 1 2225
Database Partition 0 -- Database BPEDB -- Active -- Up 4 days 00:17:34
Dynamic Cache:
Current Memory Used 63613954
Total Heap Size 63669248
Cache Overflow Flag 0
Number of References 206251322
Number of Statement Inserts 18120
Number of Statement Deletes 12549
Number of Variation Inserts 11585
Number of Statements 5571
Dynamic SQL Statements:
Address AnchID StmtUID NumEnv NumVar NumRef NumExe Text
0x070000032E3EE6C0 64 1 1 1 2897179 2897179 INSERT INTO
WPRBE00.SCOPE_COMPLETION_COUNTER_T (SIID, PIID, COUNTER, VERSION_ID ) VALUES ( ?, ?, ?, ?)