SQLLDR - Strange Question

[Quoted] I've been writing a UNIX korn shell script to collect output from SQLLDR (v8.1.7.0.0) - the "Commit point reached - logical record count 60420" stuff - and have noticed that when this output is redirected from standard output to a file (either using redirect '>>' or piped through 'tee -a', the output seems to be buffered before being written to the file. Suspiciously, the file only seems to be written to in 8K blocks (disk block size or coincidence? I have experimented on both direct IO and straight disks, and the result is the same) and so for collecting live statistics about data loads, it makes for pretty strange results.

Can anyone explain what's happening here with SQLLDR (I assume it's the application which is doing this) and also has anyone got any ideas for a work around for collecting the load statistics/progress which doesn't involve performing a count on the table which would obviously be potentially detrimental to performance.

Thanks for any help!

Cheers
Tim Received on Fri Oct 19 2001 - 17:53:13 CEST