select systimestamp from dual; 
set termout off 
set arraysize 1000 
set rowprefetch 2 
set pages 0 
set trimspool on 
spool c:\temp\test.out 
select * from ... 
spool off 
set termout on 
select systimestamp from dual; 

https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:10498431232211

you don't need to split the table into 4 -- you can just use ROWID ranges. If you use this script I call "split" 

------------------------------------------------- 


set verify off 
define TNAME=&1 
define CHUNKS=&2 


select grp, 
dbms_rowid.rowid_create( 1, data_object_id, lo_fno, lo_block, 0 ) min_rid, 
dbms_rowid.rowid_create( 1, data_object_id, hi_fno, hi_block, 10000 ) max_rid 
from ( 
select distinct grp, 
first_value(relative_fno) 
over (partition by grp order by relative_fno, block_id 
rows between unbounded preceding and unbounded following) lo_fno, 
first_value(block_id ) 
over (partition by grp order by relative_fno, block_id 
rows between unbounded preceding and unbounded following) lo_block, 
last_value(relative_fno) 
over (partition by grp order by relative_fno, block_id 
rows between unbounded preceding and unbounded following) hi_fno, 
last_value(block_id+blocks-1) 
over (partition by grp order by relative_fno, block_id 
rows between unbounded preceding and unbounded following) hi_block, 
sum(blocks) over (partition by grp) sum_blocks 
from ( 
select relative_fno, 
block_id, 
blocks, 
trunc( (sum(blocks) over (order by relative_fno, block_id)-0.01) / 
(sum(blocks) over ()/&CHUNKS) ) grp 
from dba_extents 
where segment_name = upper('&TNAME') 
and owner = user order by block_id 
) 
), 
(select data_object_id from user_objects where object_name = upper('&TNAME') ) 
/ 

-------------------------------- eof -------------------- 


and run it 

SQL> @split T 4 

it'll produce something like: 

big_table@ORA920LAP>; @split big_table 4 

GRP MIN_RID MAX_RID 
---------- ------------------ ------------------ 
0 AAAHchAAJAAAAAJAAA AAAHchAAJAAAA4ICcQ 
1 AAAHchAAJAAAA4JAAA AAAHchAAJAAABwICcQ 
2 AAAHchAAJAAABwJAAA AAAHchAAJAAACgICcQ 
3 AAAHchAAJAAACgJAAA AAAHchAAJAAADgICcQ 


those are 4 non-overlapping rowid ranges that complete "cover" the table -- so, you can query: 


for x in ( select /*+ FIRST_ROWS */ * from t where rowid between X and Y ) 
loop 

and just pass in a rowid pair for X and Y. that way, you can use the above query to generate 4 rowid ranges, insert them into the job parameter table and run 4 copies of your procedure. they'll each process about 1/4th of the table.