Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compressing Oracle SW directories and files
$ORACLE_HOME/database on Windows is the default directory.
Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Monday, January 08, 2007 5:47 AM
To: Carel-Jan Engel
Cc: oracle-l_at_freelists.org
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_at_xs4all.nl> 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_at_hotmail.com <mailto:cemail_219_at_hotmail.com> > 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
-- http://www.freelists.org/webpage/oracle-l -- Niall Litchfield Oracle DBA http://www.orawin.info
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 08 2007 - 09:59:26 CST