how full must be tablespace for autoextend
oramanFeb 13 2013 — edited Feb 15 2013hi all,
I noticed in 11gR2 as users big file tablespace was 98% full, oracle autoextended the tablespace for the next 20GB.
It wasnt traced in the alert log. Is there a view where information about it is traced?
Like if 98% is filled then perform an autoextend.
Is it always 98% ?
autoextend on next is 1gb <-- this is the mimimum size.
is there a data dictionary view where one can read why this extend went on 20gb or what is the maximum autoextend size?
I dont mean maxsize but max size of every autoextend step.
SELECT DBMS_METADATA.GET_DDL('TABLESPACE','USERS') FROM dual;
DBMS_METADATA.GET_DDL('TABLESPACE','USERS')
--------------------------------------------------------------------------------
CREATE BIGFILE TABLESPACE "USERS" DATAFILE
'path/users01.dbf' SIZE 268435456000
AUTOEXTEND ON NEXT 1073741824 MAXSIZE 652288M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEM
ENT AUTO
sorry if I'm too curious...