obscure question?

hi...
i've never seen any info on this question, tho it's a bit odd, admittedly:

can you change the frequency at which SPOOL writes to disk?

the point of the question is when i spool script output to a file, i like to monitor its progress remotely without being able to see the session in which it is running. unfortunately, the spool file is always a few statements behind the actual script due to buffering from memory to disk (right?) so i can't see in the spool file at any given point in time exactly which statement is being processed depending on how much data is being written out. i'm guessing this is an OS-related issue since i don't think Oracle sets this parameter. i'm running on Windows NT 4 and Oracle 8i. i suppose there might be another way to monitor the script, but i'm really curious about this. has anyone else ever wondered about this... or am i a lone nut-case??? Received on Tue Oct 16 2001 - 20:14:05 CDT