RE: Compressing Oracle SW directories and files
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <niall.litchfield@xxxxxxxxx>, <cjpengel.dbalert@xxxxxxxxx>
- Date: Mon, 8 Jan 2007 10:59:26 -0500
$ORACLE_HOME/database on Windows is the default directory.
Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904 727-2546
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield
Sent: Monday, January 08, 2007 5:47 AM
To: Carel-Jan Engel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Compressing Oracle SW directories and files
Carel-Jan,
I did spot that the reference was specifically SW files, though given
that even my somewhat bloated laptop 10gr2 install is only 1.88gb
without any management of the logs in it, I'd hoped/guessed that the
database/logs were included. My expectation is that compressing the
software directory will also technically work, but I have never been
that desparate for space.
Don't datafiles and arch_logs end up in the $ORACLE_HOME directory by
default on all platforms? $ORACLE_HOME/dbs on *nix i thought.
cheers
On 1/8/07, Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx> wrote:
Niall,
He's asking about _software_ dirs and files. Not about datafiles. It is
windows, where by default datafiles might end up in the software dir
anyway. I agree with you even then: it's a server! How much space is
there to be gained compressing executables and config files? One must be
short of disk (and thus short of money desperately) to go this far.
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Mon, 2007-01-08 at 06:44 +0000, Niall Litchfield wrote:
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.
On 1/8/07, J. Dex < cemail_219@xxxxxxxxxxx
<mailto:cemail_219@xxxxxxxxxxx> > wrote:
On one of our Microsoft Servers, I have been asked to compress
all of the
Oracle software directories and files. Will that cause any
issues? What
is the best way to compress them?
_________________________________________________________________
Your Hotmail address already works to sign into Windows Live
Messenger! Get
it now
http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http:/
/get.live.com/messenger/overview
--
//www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
