Techdata VINA 지식 공유

Oracle DML 작업시 효율을 극대화 시켜주는 전투 자극제

alter session set sort_area_size = 104857600 ;                          

alter session set sort_read_fac = 256 ;                                 

alter session set db_file_multiblock_read_count=10240000 ;                   

alter session set sort_write_buffers = 2000 ;                           

alter session set sort_write_buffer_size = 1048576 ;                    

alter session set sort_spacemap_size = 1048576 ;                        

alter session set sort_read_fac = 256 ;                                 

alter session set events '10355 trace name context forever, level 10' ;

alter session enable parallel dml ;

alter session set workarea_size_policy = manual ;