Re: PCTFREE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/07/06
Message-ID: <962908761.7347.3.pluto.d4ee154e@news.demon.nl>#1/1

Your assumption regarding the number datatype is not correct. Use vsize(<number column>) for the real size. Why would you want to move pctfree higher. To waste more space?

Hth,

Sybrand Bakker, Oracle DBA

"Ethan Post" <epost1_at_my-deja.com> wrote in message news:8k2iah$9v9$1_at_nnrp1.deja.com...
> I'm running an ERP application that has most of the tables set to
> PCTFREE 10 PCTUSED 40. Now almost all columns are char or number:
>
> COUNT(*) DATA_TYPE
> --------- ------------
> 32371 CHAR
> 2 LONG
> 1 LONG RAW
> 22251 NUMBER
> 46 VARCHAR2
>
> My tests show that it doesn't matter if you store a 0 or 999999999, the
> space is the same much like the behavior of a char. Is this assumption
> correct and if so moving PCTFREE even higher should not be a problem,
> correct?
>
> --
> -Ethan
> http://www.freetechnicaltraining.com
> http://www.gnumetrics.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 06 2000 - 00:00:00 CDT