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: Oracle Compress Option

Re: Oracle Compress Option

From: Ravi Kulkarni <nandagokul_at_yahoo.com>
Date: Thu, 25 Sep 2003 08:14:47 -0800
Message-ID: <F001.005D10D9.20030925081447@fatcity.com>


Raj,

How can we know if only one Pvt Interconnect is used at a given time? How are you monitoring them real-time? Is the GC traffic not load balanced ? Are you using cluster_interconnects?

Thanks,
Ravi.

> ----- Original Message -----
> From: Jamadagni, Rajendra
> To: 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
> active/active. On one instance luckily we have
> application partitioning one side manages the feeds
> that come from every foot/bast/basketball, hockey
> and scores of other games and processes them and
> sends it out to customers. Another side takes this
> data plus people sitting to make corrections if any
> before it is fed to video generators and goes on
> espn network broadcast. So it works fine.
>
> Other instances are legacy ... the active/active
> is more like a HA configuration, lots of people
> connected on either side all the time lots of DML
> activity going around all the time. We see more of a
> GC traffic ... but we are experimenting with
> _fairness_threshold parameter to see if that will
> help. As for performance issues, we encounter lots
> of BBW but unfortunately that is due to business
> logic and can't be easily changed.
>
> Otherwise we do fine.
> 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 opinion
> is an art !
> -----Original Message-----
> From: Tanel Poder
> [mailto:tanel.poder.003_at_mail.ee]
> Sent: Thursday, September 25, 2003 10:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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 of interconnect you're using?
>
> Tanel.
> ----- Original Message -----
> From: Jamadagni, Rajendra
> To: Multiple recipients of list ORACLE-L
> Sent: Thursday, September 25, 2003 4:49 PM
> Subject: 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
>
>


>
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly
> personal.
> QOTD: Any clod can have facts, having an
> opinion is an art !
> -----Original Message-----
> From: Khedr, Waleed
> [mailto:Waleed.Khedr_at_FMR.COM]
> Sent: Thursday, September 25, 2003 9:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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 slow on
> compressed tables, but I say don't even try to
> update a compressed table, uncompress first
> otherwise you will end up with a segment that is not
> good at all for scattered reads.
>
> 2) You can not add columns to the table when
> it's compressed, so if you compressed a big table
> and need a new column you need to recreate the table
> without compression. So adding many extra columns
> before compression is a good idea.
>
> It's mainly good for data warehouses
> applications.
>
> Regards,
>
> Waleed
>
> -----Original Message-----
> From: Jamadagni, Rajendra
> [mailto:Rajendra.Jamadagni_at_espn.com]
> Sent: Thursday, September 25, 2003 9:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
>
>


>
> Rajendra dot Jamadagni at nospamespn dot
> com
> All Views expressed in this email are
> strictly personal.
> QOTD: Any clod can have facts, having an
> opinion is an art !
>
>
>
> -----Original Message-----
> From: Mogens Nørgaard
> [mailto:mln_at_miracleas.dk]
> Sent: Wednesday, September 24, 2003 10:05
> PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Oracle Compress Option
>
>
>
> "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.
>
> Mogens
>
> Avnish.Rastogi_at_providence.org wrote:
>
> >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 13184MB. In both the cases I did export
> from source table and stored in two different
> tablespaces. Any insight on that and any
> disadvantages of using that.
>
> >
> >Thanks
>


Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: nandagokul_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Sep 25 2003 - 11:14:47 CDT

Original text of this message

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