| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Database on a compressed Windows NT volume?
A copy of this was sent to "LB" <remove_lbowen_at_fastrans.net>
(if that email address didn't require changing)
On Tue, 1 Dec 1998 21:24:29 GMT, you wrote:
>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!
>
DO NOT USE OS COMPRESSION ON DATAFILES/REDO FILES/CONTROL FILES. The reason you CANNOT compress them is that you might not have room to grow them later. Oracle really, truely believes it has X meg of space. If it does not really have X gig of space as the data files grow (and the compression ratio DROPS dramatically, empty datafiles compress 30 to 1 or more, full ones 1 to 1 or 2 to 1), it will get write errors on the datafiles (or even worse -- on redo logs or control files). The database will believe the disk it is using is bad and you will have to possibly recover the database (but only if you are running in archive log mode -- otherwise you are just out of luck). Don't compress your datafiles.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Tue Dec 01 1998 - 22:18:31 CST
 |
 |