Hi Gurus,

What is the avg_space in dba_tables?

create table tz(t number) storage (initial 2K next 2K pctincrease 0 minextents 5) tablespace users;

SQL> insert into tz values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> analyze table tz compute statistics;

Table analyzed.

SQL> select blocks,empty_blocks,avg_space,num_freelist_blocks
2 from dba_tables where table_name='TZ';

BLOCKS EMPTY_BLOCKS AVG_SPACE NUM_FREELIST_BLOCKS
---------- ------------ ---------- -------------------
1 4 8091 1


SQL> begin
2 for i in 1..50 loop
3 insert into tz values(i);
4 end loop;
5 end;
6 /

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> analyze table tz compute statistics;

Table analyzed.

SQL> select blocks,empty_blocks,avg_space,num_freelist_blocks
2 from dba_tables where table_name='TZ';

BLOCKS EMPTY_BLOCKS AVG_SPACE NUM_FREELIST_BLOCKS
---------- ------------ ---------- -------------------
1 4 7541 1


When we are adding the rows, the value of avg_space is decreasing. Can anyone explain this pelase?

Seelan