Re: Collocation & Compression considerations for a 1TB Oracle Dat a

ADSM-L

[Top] [All Lists]

Re: Collocation & Compression considerations for a 1TB Oracle Dat a Warehouse

2002-11-24 21:47:25

Subject:	Re: Collocation & Compression considerations for a 1TB Oracle Dat a Warehouse
From:	Mark Stapleton <stapleto AT BERBEE DOT COM>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Sun, 24 Nov 2002 20:46:24 -0600

On Wed, 2002-11-20 at 13:48, Rushforth, Tim wrote:
> We tend to get 90 % compression for a lot of our Oracle data.  So 10 GB may
> shrink to 1 GB.  Give it a try to see what compression rate you get.

It depends upon how full the allocated space for Oracle is. You can have
a 50GB abc.dbf file with 50MB of data on it. *That* sucker'll compress
way down. Its 50GB neightbor xyz.dbf with 48GB of data on it won't
compress much at all.

--
--
Mark Stapleton (stapleton AT berbee DOT com)
Certified TSM consultant
Certified AIX system engineer
MCSE

[More with this subject...]

<Prev in Thread]	Current Thread	[Next in Thread>
Re: Collocation & Compression considerations for a 1TB Oracle Dat a Warehouse, Rushforth, Tim Re: Collocation & Compression considerations for a 1TB Oracle Dat a Warehouse, Mark Stapleton <=

Previous by Date:	Re: TDP Exchange v5.1.5, Paolo Nasca
Next by Date:	Re: Error validating inserts for event 14995, Mark Stapleton
Previous by Thread:	Re: Collocation & Compression considerations for a 1TB Oracle Dat a Warehouse, Rushforth, Tim
Next by Thread:	TDP for Exchange not working, Neil Dombrowski
Indexes:	[Date] [Thread] [Top] [All Lists]