如何將事件的次數(shù)與時間統(tǒng)計出來

yuantong

請教各位SHELL高手，如何將一個文件里類似以下的內(nèi)容分類統(tǒng)計出來？

我想要：
db file sequential read   次數(shù)  ela=的時間相加
gc cr grant 2-way  次數(shù)  ela=的時間相加
....
將每一個事件的次數(shù)與消耗的時間累計

謝謝

=====================
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

復(fù)制代碼

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

Kasiotao

忘了附上結(jié)果。。。。

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

復(fù)制代碼

reb00t

回復(fù) 2#
樓上大神少了關(guān)鍵字

    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\]了,你看你的代碼,絕對不相信你會犯這個錯誤
回復(fù) 4# reb00t

   

reyleon

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

復(fù)制代碼

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

復(fù)制代碼

李滿滿

已收藏~回復(fù) 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. 結(jié)果：
    
17. db file sequential read        39921
    
18. gc cr grant 2-way        1494
    
19. buffer busy waits        25
    
20. [Finished in 0.2s]

復(fù)制代碼

李滿滿

看來這帖子收藏的有價值了~回復(fù) 8# reb00t


   

yuantong

非常感謝各位