Re: Compress database

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: 11 Jan 2007 04:46:08 -0800
Message-ID: <1168519567.472439.46390@o58g2000hsb.googlegroups.com>

oracle dba wrote:

> will it ok if I compress database files like datafiles, controlfiles
> and redo log files with ntfs compress utility.
> I mean will it not corrupt the database or it is ok.

Here's a reply I wrote a couple of days ago to a remarkably similar enquiry on Oracle-l. Sorry for those who read both.

You can do it at least to regular Oracle datafiles (laptop short of space discovery to thank for that, right along with you can hibernate an oracle database server just fine...) using NTFS compression (choose compress on the datafile directories in explorer). There will be a performance impact on the server and database (server CPU will be higher, disk io will be slower for the db) and it is almost certainly not supported by Oracle.

I'd be pushing back against this one though. Being asked to manage logs and archives is perfectly reasonable in my book. Being asked to compress production databases is unreasonable.

Niall Litchfield
Oracle DBA
http://www.orawin.info/ Received on Thu Jan 11 2007 - 06:46:08 CST