可以参考下边的并行解压脚本,
下边的脚本会同时开20个解压缩进程,在解压大批量(1万以上)的文件时,速度很快(在超过24路的SMP机器上)
for f in *gz
do
gzip -d $f &
n=`ps | wc -l`
while [ $n -gt 20 ]
do
n=`ps | wc -l`
sleep 1
done
done
DECLARE
I INTEGER := 0;
C INTEGER;
BEGIN
SELECT COUNT(*) INTO C FROM TESTTABLE005;
INSERT INTO TESTTABLE005 T005 (C01, C02) VALUES (SYSDATE, C);
COMMIT;
LOOP
INSERT INTO TESTTABLE005 T005 (C01, C02, C03) VALUES (SYSDATE, C, I);
I := I + 1;
EXIT WHEN I = 50;
END LOOP;
COMMIT;
END;
EXIT