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
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 http://www.ukoug.org/calendar/jan03/jan30ab.h
]
Sent by: cc:
[EMAIL PROTECTED] Subject: RE: Oracle Compress Option
ity.com
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 is a good presentation on this
topic (see for instance
!
-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
CTED] On Behalf Of
Jamadagni, RajendraSent: Thursday, September 25, 2003 2:40
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Compress Option
Matt,
What is 802.3ad link aggregation ?? Any handy URLs ??
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
ssage-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 bal
Multiple recipients 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
&g
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
Multiple recipients 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
&g
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 an
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
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
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.
Ta
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
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 ki
tiple 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 ...
Title: 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
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 will be
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 !
"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.
Moge
Does anybody has any experience with Oracle 9I compression option. I did some test on
9202 with a table of more 14 million rows. Table has total 7 indexes. Surprising both
table and indexes are using more space after compression. Before compression space
used is 13064MB and after compression 131
23 matches
Mail list logo
