Oracle PCTFree

Giganews Newsgroups
Subject: Oracle PCTFree
Posted by:  Vinh (huuvi…@gmail.com)
Date: 13 Jan 2005

Tablespace test is local management and segment space manual. Database
version is Oracle 9.2.0.5

create table test10 (
id number,
name varchar2(40) )
tablespace test
PCTFREE 10

;

Table created.

create table test1 (
id number,
name varchar2(40) )
tablespace test
PCTFREE 1

;

Table created.

SQL> select TABLE_NAME, PCT_FREE, PCT_USED from dba_tables
where TABLE_NAME like 'TEST%';
2
TABLE_NAME                      PCT_FREE  PCT_USED

------------------------------ ---------- ----------

TEST1                                  1
TEST10                                10

begin
for i in 1..100000
loop
insert into test10
values (i,'This is testing' ||i);
end loop;
end;
/

begin
for i in 1..100000
loop
insert into test1
values (i,'This is testing' ||i);
end loop;
end;

SQL> l
1 select SEGMENT_NAME, sum(BLOCKS) from dba_extents
2 where TABLESPACE_NAME='TEST'
3* GROUP BY SEGMENT_NAME
SQL> /

SEGMENT_NAME        SUM(BLOCKS)

-------------------- -----------

TEST1                        512
TEST10                      512

My double is how can with the different PCTFREE (1 and 10) but the
number block is the same?
If I change PCTFREE to 50, I can see the difference!!

Replies