Oracle Table Space Auto-expanding size

Select a.file_name,a.autoextensible,a.maxbytes,a.increment_by from Dba_data_files A;

Whether the--autoextensible is automatically extended

--maxbytes Max
--increment_by number of auto-expansion blocks

Sql> Show Parameter Db_block

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Db_block_buffers integer 0
Db_block_checking Boolean FALSE
Db_block_checksum Boolean TRUE
Db_block_size integer 8192


--db_block_size*increment_by Block Size * Number of blocks = auto-expanded size;



Example:
Create tablespace sq01 datafile ' d:\sq01.bdf ' size 5m; --Create TABLE space


ALTER DATABASE datafile ' D:\SQ01.BDF ' autoextend on next 20m maxsize 100m;
-- Modified table Space Auto growth 20m max space 100M per growth


Sql> Select a.file_name,a.autoextensible,a.maxbytes,a.increment_by from Dba_data_files A;

file_name autoextensible MaxBytes increment_by
-------------------------------------------------------------------------------- -------------- ---------- ------- -----
D:\SQ01. BDF YES 104857600 2560




Sql> Show Parameter Db_block

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Db_block_buffers integer 0
Db_block_checking Boolean FALSE
Db_block_checksum Boolean TRUE
Db_block_size integer 8192


Sql> Select 2560*8192/1024/1024| | ' M ' from dual;

2560*8192/1024/1024| | ' M
------------------------

20M