oracle spool生成文件,请教oracle spool 导出文本文件的内在原理及其瓶颈是什么？...

SQLULDR2W.exe 工具； 3分钟500W

0 rows exported at 2010-09-08 11:21:25, size 0 MB.

100000 rows exported at 2010-09-08 11:21:28, size 24 MB.

200000 rows exported at 2010-09-08 11:21:33, size 52 MB.

300000 rows exported at 2010-09-08 11:21:37, size 80 MB.

400000 rows exported at 2010-09-08 11:21:40, size 104 MB.

500000 rows exported at 2010-09-08 11:21:44, size 132 MB.

600000 rows exported at 2010-09-08 11:21:47, size 156 MB.

700000 rows exported at 2010-09-08 11:21:51, size 184 MB.

800000 rows exported at 2010-09-08 11:21:54, size 212 MB.

900000 rows exported at 2010-09-08 11:21:58, size 236 MB.

1000000 rows exported at 2010-09-08 11:22:02, size 264 MB.

1100000 rows exported at 2010-09-08 11:22:05, size 292 MB.

1200000 rows exported at 2010-09-08 11:22:09, size 316 MB.

1300000 rows exported at 2010-09-08 11:22:13, size 344 MB.

1400000 rows exported at 2010-09-08 11:22:16, size 372 MB.

1500000 rows exported at 2010-09-08 11:22:19, size 400 MB.

1600000 rows exported at 2010-09-08 11:22:25, size 424 MB.

1700000 rows exported at 2010-09-08 11:22:31, size 452 MB.

1800000 rows exported at 2010-09-08 11:22:36, size 480 MB.

1900000 rows exported at 2010-09-08 11:22:39, size 504 MB.

2000000 rows exported at 2010-09-08 11:22:43, size 532 MB.

2100000 rows exported at 2010-09-08 11:22:47, size 560 MB.

2200000 rows exported at 2010-09-08 11:22:50, size 588 MB.

2300000 rows exported at 2010-09-08 11:22:54, size 612 MB.

2400000 rows exported at 2010-09-08 11:22:57, size 640 MB.

2500000 rows exported at 2010-09-08 11:23:01, size 668 MB.

2600000 rows exported at 2010-09-08 11:23:04, size 696 MB.

2700000 rows exported at 2010-09-08 11:23:08, size 720 MB.

2800000 rows exported at 2010-09-08 11:23:11, size 748 MB.

2900000 rows exported at 2010-09-08 11:23:14, size 776 MB.

3000000 rows exported at 2010-09-08 11:23:18, size 800 MB.

3100000 rows exported at 2010-09-08 11:23:21, size 828 MB.

3200000 rows exported at 2010-09-08 11:23:25, size 852 MB.

3300000 rows exported at 2010-09-08 11:23:28, size 880 MB.

3400000 rows exported at 2010-09-08 11:23:32, size 908 MB.

3500000 rows exported at 2010-09-08 11:23:37, size 932 MB.

3600000 rows exported at 2010-09-08 11:23:40, size 960 MB.

3700000 rows exported at 2010-09-08 11:23:44, size 988 MB.

3800000 rows exported at 2010-09-08 11:23:48, size 1012 MB.

3900000 rows exported at 2010-09-08 11:23:52, size 1040 MB.

4000000 rows exported at 2010-09-08 11:23:56, size 1068 MB.

4100000 rows exported at 2010-09-08 11:24:01, size 1096 MB.

4200000 rows exported at 2010-09-08 11:24:04, size 1120 MB.

4300000 rows exported at 2010-09-08 11:24:08, size 1148 MB.

4400000 rows exported at 2010-09-08 11:24:12, size 1176 MB.

4500000 rows exported at 2010-09-08 11:24:15, size 1204 MB.

4600000 rows exported at 2010-09-08 11:24:19, size 1228 MB.

4700000 rows exported at 2010-09-08 11:24:23, size 1256 MB.

4800000 rows exported at 2010-09-08 11:24:27, size 1284 MB.

4900000 rows exported at 2010-09-08 11:24:31, size 1312 MB.

5000000 rows exported at 2010-09-08 11:24:34, size 1340 MB.

5100000 rows exported at 2010-09-08 11:24:38, size 1368 MB.

5200000 rows exported at 2010-09-08 11:24:42, size 1392 MB.

5300000 rows exported at 2010-09-08 11:24:45, size 1420 MB.

5400000 rows exported at 2010-09-08 11:24:49, size 1448 MB.

5500000 rows exported at 2010-09-08 11:24:53, size 1476 MB.

5572866 rows exported at 2010-09-08 11:24:55, size 1497 MB.

output file E:\1.txt closed at 5572866 rows, size 1497 MB.