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.

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.
>
It is not ok to compress db files when the database is open

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.

Why? What exactly are you trying to achieve?

On Jan 11, 10:10 am, "oracle dba" <aoracle...@gmail.com> 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.

Theoretically you could locate datafiles on a compressed disk, but you
will probably perceive a performance hit.
As disk is cheap nowadays, you will probably create more problems than
you are trying to resolve. Also : what are you trying to resolve? Lack
of disk space?
Then go to the shop around the corner and buy disks.

--
Sybrand Bakker
Senior Oracle DBA

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/

On Jan 11, 1:46 pm, "Niall Litchfield" <niall.litchfi...@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