Re: Oracle 7.3.x.x on NT4

In article <01bd4cb0$0da4c860$0d12d88f_at_HI2_LB7_TN.health.sa.gov.au>, T Nguyen <nguyen.thanh_at_health.sa.gov.au> writes
>Hi experts,
>We are running Oracle Workgroup 7.3.2.2.1 and believe that this version is
>not a stable one on NT4 (has bugs and sucks up memory). We have run a patch
>to bring it up to 7.x.x.14 but if we could do it bettter we would ....
>We would like to know which version in the 7.3.x.x is the most reliable one
>to run on NT4 so we can upgrade to the right version. Is 7.3.3 the one ?
>If your site is having a smooth running version of Oracle on NT then please
>drop us a line. Should we consider Oracle 8 ?
>I would appreciate any advice.
>TIA

We had some memory leaks and other issues with 7.3.2 (NT4 Build 1381 SP zero), all of which disappeared with 7.3.3.0.0, and yes, I would certainly say 7.3.3 is the one - so far; although we do still have one unresolved problem (relating to grants on views containing user-defined functions, but we are able to work around that one). I am about to start considering Oracle8, but plan a *very* thorough test before implementing it live (then again I am the sort of reactionary who always tends to wait for the 'point-one' version of any software).

HTH. Good luck.

P.S. By the way, does anyone know why the service now appears to hold the datafiles open even after a shutdown? This didn't happen with earlier incarnations on NT. It stops us doing cold backups to tape (although we can do cross-disk copies). We could work around this by doing 'net stop OracleService<sid>' after the shutdown but I don't feel entirely comfortable with that.

P.P.S What is the NT equivalent of 'sync' (i.e. flush cached disk writes at OS level)?

-- 
Paul Brewer