Re: Compress database

On Jan 11, 1:46 pm, "Niall Litchfield" <niall.litchfi..._at_gmail.com> wrote:
> 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 DBAhttp://www.orawin.info/

Fully agree. One doesn't want to hear OTS tell you 'We don't support this' after disaster already has struck.

-- 
Sybrand Bakker
Senior Oracle DBA