Table's pctfree value
From: Stefano UNTERNAEHRER <unter_at_mecati.mecasoft.ch>
Date: 1995/07/03
Message-ID: <DB5pAr.C8u_at_mecati.mecasoft.ch>#1/1
Date: 1995/07/03
Message-ID: <DB5pAr.C8u_at_mecati.mecasoft.ch>#1/1
Please clear or confirm this sentences (Oracle7):
- A VARCHAR2 datatype columns only allocates the needed space,
while a CHAR datatype columns allocates the space for all the
possible chars.
(This MUST be right!)
- A NUMBER datatype columns always allocates the space for all the possible digits.
- A DATE datatype columns always allocates the space for a date,
(7 bits).
If sentences 2 and 3 are right, then:
4) A table having only NUMBER and/or DATE as columns datatype
is supposed to have pctfree=0, because no future updates will require extra space.
5) An index is supposed to always have pctfree=0, because his
values (table's primary keys) will be never changed.
I suppose 2 and 3 (and 4) are wrongs...
Can you confirm?
______________________| Stefano Unternaehrer |__________________________ \ Mecasoft SA | Oracle DBA | fax: +41 93 335 507 / \ 6600 Muralto | and PL/SQL, Pro*C | voice: +41 93 337 444 / \ | C, XWindow & Motif | / / | Software Developer | email: \ / Switzerland Europe |____________________________| dba,unter_at_mecasoft.ch \ /________________________) (____________________________\Received on Mon Jul 03 1995 - 00:00:00 CEST
