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: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 8 Jan 2007 10:47:07 +0000
Message-ID: <7765c8970701080247t3774598fw1a8e9053d4875ea0@mail.gmail.com>


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> 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 - 04:47:07 CST

Original text of this message

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