commit every 1000 insert
The below code not working.. goal is.. transaction should commit when inserted 1000 records with good performance.
CREATE OR REPLACE PROCEDURE test_proc (p_array_size IN PLS_INTEGER DEFAULT 1000)
IS
TYPE ARRAY IS TABLE OF EBH_SLA_AGGREGATED_DATA %ROWTYPE;
l_data ARRAY;
CURSOR c IS SELECT /*+ nologging */ TIME_STAMP, ROLLUP_INTERVAL,CELLSITE_ID,INTERVALS_TOTAL,INTERVALS_UNAVAIL,INTERVALS_UNKNOWN,TRAILING_PATH1_EMPTY,TRAILING_PATH2_EMPTY,TX_FRAMES_TOTAL,LOST_FRAMES_TOTAL,RX_FD_AVG_TOTAL,
RX_FDV_AVG_TOTAL,
FD_MAX_TOTAL,
FDV_MAX_TOTAL,
INTERVALS_TOTAL_PATH1,
INTERVALS_TOTAL_PATH2,
INTERVALS_UNAVAIL_PATH1,
INTERVALS_UNAVAIL_PATH2,
INTERVALS_UNKNOWN_PATH1,