Oracle PCTFree

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!! Received on Thu Jan 13 2005 - 02:44:16 CST