procedure prc_HECTOR_CIDB_IN_PURGE
IS
      cursor CUR_PROC is
      select rowid from CUSTMODEL.HECTOR_CIDB_IN where PROCESS_FLAG in ('Y','F');

      TYPE TYP_CUR_DATA IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
      v_typ_cur_data typ_cur_data;

BEGIN
      OPEN CUR_PROC;
      LOOP
          v_typ_cur_data.DELETE;

          FETCH CUR_PROC BULK COLLECT INTO v_typ_cur_data LIMIT 10000;

          IF V_TYP_CUR_DATA.COUNT > 0
          THEN
              FORALL J in 1..V_TYP_CUR_DATA.COUNT
                  DELETE FROM custmodel.HECTOR_cidb_in WHERE ROWID=v_typ_cur_data(j);
                  COMMIT;
                  --dbms_output.put_line('Count '||V_TYP_CUR_DATA.COUNT);
              ELSE
              EXIT;
          END IF;
          END LOOP;

      CLOSE CUR_PROC;
      COMMIT;

EXCEPTION
          WHEN OTHERS
          THEN
              IF CUR_PROC%ISOPEN
              then
                  CLOSE CUR_PROC;
              end if;
END prc_hector_cidb_in_PURGE;

SQL> show parameter parallel

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
fast_start_parallel_rollback         string      FALSE
parallel_adaptive_multi_user         boolean     TRUE
parallel_automatic_tuning            boolean     FALSE
parallel_degree_limit                string      CPU
parallel_degree_policy               string      MANUAL
parallel_execution_message_size      integer     16384
parallel_force_local                 boolean     FALSE
parallel_instance_group              string
parallel_io_cap_enabled              boolean     FALSE
parallel_max_servers                 integer     960
parallel_min_percent                 integer     0
parallel_min_servers                 integer     0
parallel_min_time_threshold          string      AUTO
parallel_server                      boolean     TRUE
parallel_server_instances            integer     2
parallel_servers_target              integer     384
parallel_threads_per_cpu             integer     2
recovery_parallelism                 integer     0

SQL> select degree,table_name,owner from dba_tables where table_name='HECTOR_CIDB_IN';

DEGREE     TABLE_NAME                     OWNER
---------- ------------------------------ ------------------------------
         1 HECTOR_CIDB_IN                 CUSTMODEL

SQL> select degree,instances from dba_tables where table_name='HECTOR_CIDB_IN';

DEGREE     INSTANCES
---------- ----------
         1          1