begin 
dbms_system.set_ev(862, 7833, 10046, 8, ''); 
end; 
/

tkprof work_ora_320.trc output=320.txt sort=(prsela,exeela,fchela)

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       28      0.01       0.01          0          0          0           0
Execute     28      0.00       0.01          0          0          0           0
Fetch       28    376.75     378.90        207    5349593        224         346
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       84    376.77     378.92        207    5349593        224         346

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      196      0.01       0.02          0          0          0           0
Execute    196      0.03       0.03          0          0          0           0
Fetch      197    437.61     442.69       3480    6280167        260         474
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      589    437.66     442.75       3480    6280167        260         474

Misses in library cache during parse: 0

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file sequential read                      3482        0.37          3.14
  SQL*Net message to client                     981        0.00          0.00
  SQL*Net more data to client                    62        0.00          0.00
  SQL*Net message from client                   981        0.20          6.78
  SQL*Net more data from client                1792        0.00          0.06
  direct path write temp                         28        0.00          0.00
  latch: row cache objects                        5        0.00          0.00
  latch: cache buffers chains                    12        0.00          0.00


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute 321307      9.39       8.90          0          0          0           0
Fetch   321307      6.86       7.09         86    1015917          0      321307
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   642614     16.25      16.00         86    1015917          0      321307

Misses in library cache during parse: 0

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  db file sequential read                        86        0.00          0.02
  cursor: pin S                                  13        0.00          0.00

   23  user  SQL statements in session.
    0  internal SQL statements in session.
   23  SQL statements in session.

 /*+ gather_plan_statistics */

SELECT *
FROM table(DBMS_XPLAN.DISPLAY_CURSOR(FORMAT=>'ALLSTATS LAST ALL +OUTLINE'));