oracle11g - Bulk collect in Oracle running slow -

oracle11g - Bulk collect in Oracle running slow -

i trying load 90k info source table manipulations in target table .i have created procedure uses bulk collect limit whenever execute throws:

ora-02395: exceeded phone call limit on io usage ora-06512: @ "insert_extract_table", line 46 ora-06512: @ line 1 02395. 00000 - "exceeded phone call limit on io usage" *cause: *action:

my code

create or replace procedure insert_extract_table( v_array_size in pls_integer default 100) pls_integer; type array table of miscdh_mig_party_list%rowtype; v_data array; cursor v_cur select p1 orig_party_id, p2 orig_party_number, p3 orig_party_name, l_id, l_rel_code , s_id, s_rel_code, case when l_rel_code='partent' p1 when l_rel_code='child' (select p1 mapping b b.s_rel_code='parent' , b.s_id =a.s_id ) end mig_party_id, case when l_rel_code ='parent' or s_rel_code='parent' 'a' when l_rel_code ='child' , s_rel_code null 'm' end mig_status, null mig_status_desc, 'ma' created_by, sysdate creation_date, 'ma' last_updated_by, sysdate last_update_date mapping a; begin open v_cur; loop fetch v_cur mass collect v_data limit v_array_size; forall in v_data.first ..v_data.last save exceptions insert miscdh_mig_party_list values v_data(i); commit; exit when v_cur%notfound; end loop; close v_cur; end insert_extract_table;

i using oracle 11g .can provide me tips how can tune code?

oracle oracle11g bulkinsert query-performance