Re: obscure question?

In a valiant and sublime effort,Jason
dipped a thumbnail in soot and doodled:

>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???
>
>

Interesting question. AFAIK:

NT uses a write-behind cache by default. So you'll never see the output immediately after it's created. Also, the frequency of writes to disk is directly linked to the sector size the partition was formatted with. Usually, the C: drive is formatted by default with a sector size of 512. Other drive/partitions may be formatted with other default sector sizes, usually larger than 512. You may well find that you can follow the output better if you spool to a file oin the C: drive.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Oct 17 2001 - 06:52:58 CDT