Re: Oracle Database on a compressed Windows NT volume?

I know someone who did it on an NT box with 2 gigs of RAM. Each and every day they had to reboot the NT server (or it got rebooted for them). They were not aware that they had done this and when I went on site I noticed that when the instance started up the RAM went from 1.9 Gigs free to 1 Meg to 200K free. Which I thought rather odd since Oracle was the only thing running on this machine and the SGA was under 300 Megs and no one had connected yet!

The data files were 15 gigs in size and the performance was nor really good (It was a quad pentium Pro by Compaq) and there were only 15 to 30 users on they system at a time (OLTP type of application). I our lab we had had several hundred users with better performance, but of course we never tried to compress the NTFS drive.

Once we shut the database down and uncompressed the files (which you have to do one by one if the files are large - NT fails to uncompress but it does not tell you it failed; so it took all night to baby sit the darn thing.). Once we got the files uncompressed the thing did not need daily rebooting and the performance was much better. Also the available RAM once the instance started up was what you would expect just under 1.7 gigs available.

Moral of the story is while it is possible I would not do it. Jim
LB wrote in message ...
>Does anybody know if an Oracle database can be run on a compressed NTFS
>volume? If so, how does it affect performance? I've dug through Oracle's
>documentation without finding any clues on the viability of this option.
>I'd appreciate any feedback from the Oracle community. Thanks!
>
>
Received on Wed Dec 02 1998 - 00:35:27 CST