PCTFREE

From: Ethan Post <epost1_at_my-deja.com>
Date: 2000/07/06
Message-ID: <8k2iah$9v9$1@nnrp1.deja.com>#1/1

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