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} '