Shell Programming and Scripting

Trace file: pudwh_ora_9998.trc
Sort options: fchela  exeela  
***************************************************************count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing 
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
***************************************************************
CREATE TABLE UAC_37662_ga NOLOGGING  AS SELECT DISTINCT 
  CRM.CI_CUST_INFO.NAP_INT_CUST_NUM FROM CRM.CI_CUST_INFO WHERE 
  CRM.CI_CUST_INFO.LAST_MIV_STATUS_PAC_DECSR IN ( 'פעיל' )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      1     18.31     239.91        326    4999384        631      368776
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        1     18.31     239.91        326    4999384        631      368776

Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 94  
***************************************************************
SELECT NAP_INT_CUST_NUM 
FROM
 UAC_37662_ga ORDER BY NAP_INT_CUST_NUM 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch       74      0.51       0.59          0        155          0      368776
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       76      0.51       0.59          0        155          0      368776

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 94  
....

    elapsed 
 ---------- 
       0.00 
     239.91 
       0.00 
 ---------- 
     239.91 


    elapsed 
 ---------- 
       0.00 
       0.00 
       0.59 
 ---------- 
       0.59

cat filename.txt | awk '{print $4} '

awk '
    /total / { 
        printf( "%s\n\n",  $4);     # print total and stop snarfing
        snarf = 0; 
        next; 
    }

    snarf > 0 {             # ok to snarf, so print the field
        print $4; 
        next; 
    }

    /call count cpu elapsed / {         # trigger the start of printing
        print $4; 
        snarf = 1; 
        next; 
    }
' input_file

mute@atom:~$ awk '/^call/,/^$/ { print $4 }' file
elapsed
----------
0.00
239.91
0.00
----------
239.91

elapsed
----------
0.00
0.00
0.59
----------
0.59

 printf("%10s\n", $4)

awk '$1=="call"{f++}f{print $4}$1=="total"{f--}' file