如何将事件的次数与时间统计出来

yuantong

请教各位SHELL高手，如何将一个文件里类似以下的内容分类统计出来？

我想要：
db file sequential read   次数  ela=的时间相加
gc cr grant 2-way  次数  ela=的时间相加
....
将每一个事件的次数与消耗的时间累计

谢谢

=====================
PARSING IN CURSOR #4576458312 len=234 dep=1 uid=44 oct=6 lid=44 tim=11666131325248 hv=2466557507 ad='700010bd1aa1f10' sqlid='gb5m2jy9h9bk3'
UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ MTL_SYSTEM_ITEMS_INTERFACE MSII SET PROCESS_FLAG = PROCESS_FLAG + 30000 WHERE TRANSACTION_TYPE IN ('UPDATE','SYNC') AND PROCESS_FLAG < 30000 AND SET_PROCESS_ID = :B1
END OF STMT
PARSE #4576458312:c=12,e=33,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=2,plh=541562793,tim=11666131325248
BINDS #4576458312:
Bind#0
  oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00
  oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0
  kxsbbbfp=110a1e810  bln=22  avl=02  flg=09
  value=7
WAIT #4576458312: nam='db file sequential read' ela= 823 file#=14 block#=107398 blocks=1 obj#=382141 tim=11666131333127
WAIT #4576458312: nam='db file sequential read' ela= 1583 file#=14 block#=107400 blocks=1 obj#=382141 tim=11666131337257
WAIT #4576458312: nam='db file sequential read' ela= 346 file#=14 block#=107388 blocks=1 obj#=382141 tim=11666131343682
WAIT #4576458312: nam='db file sequential read' ela= 597 file#=14 block#=108528 blocks=1 obj#=382141 tim=11666131371732
WAIT #4576458312: nam='db file sequential read' ela= 562 file#=14 block#=108530 blocks=1 obj#=382141 tim=11666131374785
WAIT #4576458312: nam='gc cr grant 2-way' ela= 336 p1=14 p2=110320 p3=1 obj#=382141 tim=11666131411264
WAIT #4576458312: nam='db file sequential read' ela= 388 file#=14 block#=110320 blocks=1 obj#=382141 tim=11666131411805
WAIT #4576458312: nam='gc cr grant 2-way' ela= 306 p1=14 p2=110328 p3=1 obj#=382141 tim=11666131421697
WAIT #4576458312: nam='db file sequential read' ela= 432 file#=14 block#=110328 blocks=1 obj#=382141 tim=11666131422238
WAIT #4576458312: nam='gc cr grant 2-way' ela= 282 p1=14 p2=110837 p3=1 obj#=382141 tim=11666131429113
WAIT #4576458312: nam='db file sequential read' ela= 285 file#=14 block#=110837 blocks=1 obj#=382141 tim=11666131429478
WAIT #4576458312: nam='gc cr grant 2-way' ela= 298 p1=14 p2=110831 p3=1 obj#=382141 tim=11666131435782
WAIT #4576458312: nam='db file sequential read' ela= 376 file#=14 block#=110831 blocks=1 obj#=382141 tim=11666131436207
WAIT #4576458312: nam='gc cr grant 2-way' ela= 272 p1=14 p2=111312 p3=1 obj#=382141 tim=11666131459069
WAIT #4576458312: nam='db file sequential read' ela= 370 file#=14 block#=111312 blocks=1 obj#=382141 tim=11666131459547
WAIT #4576458312: nam='db file sequential read' ela= 25239 file#=14 block#=111893 blocks=1 obj#=382141 tim=11666131490600
WAIT #4576458312: nam='db file sequential read' ela= 880 file#=14 block#=111883 blocks=1 obj#=382141 tim=11666131501322
WAIT #4576458312: nam='db file sequential read' ela= 597 file#=14 block#=112401 blocks=1 obj#=382141 tim=11666131506411
WAIT #4576458312: nam='db file sequential read' ela= 1129 file#=14 block#=112403 blocks=1 obj#=382141 tim=11666131509186
WAIT #4576458312: nam='db file sequential read' ela= 1646 file#=14 block#=112407 blocks=1 obj#=382141 tim=11666131515292
WAIT #4576458312: nam='db file sequential read' ela= 1224 file#=14 block#=112934 blocks=1 obj#=382141 tim=11666131523676
WAIT #4576458312: nam='db file sequential read' ela= 1299 file#=14 block#=112926 blocks=1 obj#=382141 tim=11666131532217
WAIT #4576458312: nam='db file sequential read' ela= 801 file#=14 block#=112928 blocks=1 obj#=382141 tim=11666131536035
WAIT #4576458312: nam='db file sequential read' ela= 525 file#=14 block#=112924 blocks=1 obj#=382141 tim=11666131545224
WAIT #4576458312: nam='db file sequential read' ela= 434 file#=14 block#=113478 blocks=1 obj#=382141 tim=11666131548784
WAIT #4576458312: nam='db file sequential read' ela= 385 file#=14 block#=113476 blocks=1 obj#=382141 tim=11666131564560
WAIT #4576453096: nam='buffer busy waits' ela= 7 file#=14 block#=73632 class#=1 obj#=121003 tim=11666133750625
WAIT #4576453096: nam='buffer busy waits' ela= 16 file#=14 block#=73666 class#=1 obj#=121003 tim=11666133755790
WAIT #4576453096: nam='buffer busy waits' ela= 2 file#=14 block#=73668 class#=1 obj#=121003 tim=11666133756097

Kasiotao

1. awk -F\' '{a[$2]++;split($3,A,/ /);b[$2]+=A[3]}END{for(i in a){print i,a[i],"ela=",b[i]}}' testfile

复制代码

是不是你的要的意思，试试看

Kasiotao

忘了附上结果。。。。

1. buffer busy waits 3 ela= 25
   
2. gc cr grant 2-way 5 ela= 1494
   
3. db file sequential read 21 ela= 39921
   

复制代码

reb00t

回复 2#
楼上大神少了关键字

    awk -F\' '/nam/{a[$2]++;split($3,A,/ /);b[$2]+=A[3]}END{for(i in a){print i,a,"ela=",b}}'  1

李满满

充气大神~看来是被CU屏蔽掉a\[i\] b\[i\]了,你看你的代码,绝对不相信你会犯这个错误
回复 4# reb00t

   

reyleon

1. echo $[$(grep -Po "(?<=nam='db file sequential read' ela= )\d+" file | tr '\n' '+') 0]

复制代码

1. echo $[$(grep -Po "(?<='gc cr grant 2-way' ela= )\d+" file | tr '\n' '+') 0]

复制代码

李满满

已收藏~回复 6# reyleon


   

reb00t

1. <?php
   
2. 
   
3. $file = file('200.txt');
   
4. $arr = array();
   
5. foreach ($file as $k => $v) {
   
6.         preg_match('/nam=\'(.*)\' ela= ([^\s]+)/', $v,$match);
   
7.         if(!empty($match)) $arr[$match[1]]+=$match[2];
   
8. }
   
9. 
   
10. foreach ($arr as $kk => $vv) {
    
11.     echo  $kk."\t".$vv."\n";
    
12. }
    
13. 
    
14. ?>
    
15. 
    
16. 结果：
    
17. db file sequential read        39921
    
18. gc cr grant 2-way        1494
    
19. buffer busy waits        25
    
20. [Finished in 0.2s]

复制代码

李满满

看来这帖子收藏的有价值了~回复 8# reb00t


   

yuantong

非常感谢各位