perfomance enhancement 썸네일형 리스트형 [Oracle] SQL * Loader 성능 향상 III Load data in Parallel in Direct Mode with Split the data file 대용량의 데이터 파일을 잘게 쪼개서 로더를 사용하여 올린다 . /usr/bin/split -l2000000 /u01/oratest/sales_data.dat sales 2백만건씩 쪼개서 파일 만들기 When “the direct load test” was running , I observed the CPU, memory and disks utilization; Potentially they have not been used much. With 8 CPUs and 16 GB RAM, my aim was how I should beat 114 seconds, got from the “DIRE.. 더보기 이전 1 다음