Re: How's this for space saving:
- From: rjamya <rjamya@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Wed, 13 Jul 2005 11:53:07 -0400
using Intel Pentium Processor for division again?
Raj
On 7/13/05, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> wrote:
>
>
> 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
>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
Other related posts:
