Thursday, March 17, 2011

What to define before huge table load?

ALTER SESSION SET WORKAREA_SIZE_POLICY=MANUAL;
ALTER SESSION SET SORT_AREA_SIZE=600000000;
ALTER SESSION FORCE PARALLEL DML PARALLEL 4;
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 4;
ALTER SESSION SET DB_FILE_MULTIBLOCK_READ_COUNT = 128;

No comments: