Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compressing Oracle SW directories and files

RE: Compressing Oracle SW directories and files

From: <Joel.Patterson_at_crowley.com>
Date: Mon, 8 Jan 2007 10:59:26 -0500
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B02762C49@jax-mbh-01.jax.crowley.com>


$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-l
Received on Mon Jan 08 2007 - 09:59:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US