Re: How's this for space saving:

From: <jo_holvoet_at_amis.com>
Date: Wed, 13 Jul 2005 17:47:50 +0200
Message-id: <OF8DB761DE.76A143C5-ONC125703D.00569F2C@eu.amis.com>

I've seen the same on occasion (in 9.2.0.4 at least). On a related note, the values Oracle gets for OPT_CMPR_COUNT have (in my limited experience and testing) always been correct (i.e. if I try to compress more the index starts growing again). Anyone have experiences to the contrary ?

mvg/regards

                                                                                                                                         
                      "Jonathan Lewis"                                                                                                   
                      <jonathan_at_jlcomp.d         To:      "oracle-l" <oracle-l_at_freelists.org>                                            
                      emon.co.uk>                cc:                                                                                     
                      Sent by:                   Subject: How's this for space saving:                                                   
                      oracle-l-bounce_at_fr                                                                                                 
                      eelists.org                                                                                                        
                                                                                                                                         
                                                                                                                                         
                      07/13/2005 17:07                                                                                                   
                      Please respond to                                                                                                  
                      jonathan

Validate index XXX;
select opt_cmpr_count, opt_compr_pctsave from index_stats;

OPT_CMPR_COUNT OPT_COMPR_PCTSAVE
-------------- -----------------

              3                233

So if I compress this index, I can reduce it's space usage by 233% ! (And I've only just created it at pctfree = 10 - so that's not because of current empty space).

Regards

Jonathan Lewis

Now waiting on the publishers: Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 8th July 2005

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 13 2005 - 10:50:30 CDT