autoextend on next size
oramanFeb 6 2013 — edited Feb 7 2013hi experts,
I would like to know what is the best tablespace "autoextend on next" size for the performance of the db?
oracle 11gR2 on redhat
users.dbf (is the only tablespace for tables) size is 330 gb
daily db growth is between 1 gb and 2 gb
tablespace ddl is:
CREATE BIGFILE TABLESPACE "USERS" DATAFILE
'path/users01.dbf' SIZE 268435456000
AUTOEXTEND ON NEXT 1310720 MAXSIZE 33554431M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEM
ENT AUTO
ALTER DATABASE DATAFILE
'path/users01.dbf' RESIZE 351655690240
do I undestand it right that the unit of "AUTOEXTEND ON NEXT 1310720" is byte?
this meand that the minimum autoextend size is 1,25 mb.
what is the maximum autoextend size per 1 autoextend operation? I havent found any info on this in the documentation.
how often should the autoextend operation happen for the good performance in the db with much DML ?
thanks in advance!