Originally posted by TimHall
In addition the close makes it possible for multiple sessions to write to the same file with fewer clashes.
I generate the file name from the AUDSID to avoid this - depends what you want to do.
Originally posted by TimHall
The loss of speed doesn't bother me too much because it wouldn't "normally" be running in production.
Candyman doesn't say, but I got the impression that there was a lot of i/o.

This oracle-base site has some good stuff on it. Any idea who runs it?