Re: obscure question?

Hi

I know this isn't the answer to the spool question, but...

Under Unix you could create a pipe with the same name the trace file would be for the session and then cat the pipe through awk and grep out the relevant lines that you need to see real time progress. Under NT, you could use Perl or install cygwin, or use gawk, etc to get the same effect. Using the pipe means you wont eat disk space, or you could just let the trace file create as normal and tail -f it.

Using this method you could get the statements from the trace file that is being executed at the time.

HTH Pete Finnigan
www.pentest-limited.com

In article <xX4z7.136207$5A3.43536002_at_news1.rdc2.pa.home.com>, Jason <foucault4_at_home.com> writes
>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???
>
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com