Not at all, Chris - here you go.
Chris Stephens wrote:
Hey Mogens...
Would you mind sending me a copy of that paper?
Thanks either way!!
chris
-Original Message-
Sent: Wednesday, September 24, 2003 9:05 PM
To: Multiple recipients of list ORACLE-L
Compress to impress? by Julian Dyke
Title: RE: Oracle Compress Option
I think 9202 doesn't like to export compressed tables in direct mode ... so watch out for that ... I implemented, tested and next day reverted back to regular tables due to this export issue. Disk is cheap.
A BAARF party member wannabe !!
Raj
Title: RE: Oracle Compress Option
Disk is not cheap
if you pay for high availability configuration. I compress historical data on
daily basis and was able to save 70 percent of the disk space. Imagine the
amount of savings for five TB.
Two major
issues:
1) Oracle says
updates
recipients of list ORACLE-LSubject: RE:
Oracle Compress Option
Waleed, I get your point ...
We have 6 RAC instances that run active-active ... and compared to
availability requirements, we (incl management) decided that disk is
cheap.
I guess it is relative ...
Raj
Title: RE: Oracle Compress Option
Hm, interesting...
How does your active-active config work, do you
have write activity on all nodes?
I'd be interested in any performance issues you had
or currently have...
Have you partitioned your application or data usage
somehow?
What kind
Title: RE: Oracle Compress Option
Something else I
forgot, full segment scans becomes faster, since he segment is 70 percent
smaller.
So this could
help balancing resource utilization between the CPUs and IO.
Waleed
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL
Title: RE: Oracle Compress Option
Hi!
I think in DW style environments, compressed fact
tables and indexes on them can give more benefit than just saved disk storage
- if you save 50% in space due compression, then 100% more data can be read
in single IO as well.
Tanel.
- Original
Title: RE: Oracle Compress Option
we have 2 gbit private interconnects of which only one is used at any
given time. Everyone else talks to the dbs using public network. Both are
active/active. On one instance luckily we have application partitioning one side
manages the feeds that come from
Title: RE: Oracle Compress Option
Thanks for the information.
One more question, is your interconnect ethernet
based or proprietary such hyperfabric for hp etc..
Thanks,
Tanel.
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Title: RE: Oracle Compress Option
ethernet ... gBit ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having
of list ORACLE-L
Sent: Thursday, September 25, 2003 6:19 PM
Subject: RE: Oracle Compress Option
we have 2 gbit private interconnects of which only
one is used at any given time. Everyone else talks
to the dbs using public network. Both are
active/active. On one instance luckily we
Title: RE: Oracle Compress Option
we monitor it through nmon ... (aix utility). GC traffic is not load balanced across both interconnects if that is what you mean. There is no way ... first one is used and if that fails the second is used. We are NOT using cluster interconnects I saw some bug
of list ORACLE-L
Sent: Thursday, September 25, 2003 6:19 PM
Subject: RE: Oracle Compress Option
we have 2 gbit private interconnects of which only
one is used at any given time. Everyone else talks
to the dbs using public network. Both are
active/active. On one instance luckily we
-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jamadagni, RajendraSent: Thursday, September 25, 2003 12:45
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Compress Option
we monitor it through nmon ... (aix utility). GC traffic is
not load balanced across
have facts, having an opinion is an art !
-Original Message-From: Matthew Zito
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 1:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Compress Option
On
our appliance, to get around the irritating load
!
-Original Message-From: Matthew Zito
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 25, 2003 3:20
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Compress Option
What
is 802.3ad link aggregation? Tell you what - buy the box and I'll tell
ya how it works
]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Oracle Compress Option
ity.com
Yes please, my email id is [EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 24, 2003 7:05 PM
To: Multiple recipients of list ORACLE-L
Compress to impress? by Julian Dyke is a good presentation on this
topic (see for instance
Compress to impress? by Julian Dyke is a good presentation on this
topic (see for instance http://www.ukoug.org/calendar/jan03/jan30ab.htm).
I do have the article - 202 K with no compression, 147 K with
compression :).
Let me know if you're interested, and I'll email it directly to you.
19 matches
Mail list logo
