datafile autoextend value doesn't honor increment_by?
Hi All,
Have fresh Oracle 19.10 on RHEL8, not using ASM, created bigfile tablespace like this
create bigfile tablespace MY_TS datafile size 512M autoextend on next 512M maxsize unlimited;
In the data dictionary everything seems to be fine:
SQL> select BLOCK_SIZE from dba_tablespaces where TABLESPACE_NAME='MY_TS'; BLOCK_SIZE 8192 SQL> select file_id, AUTOEXTENSIBLE, INCREMENT_BY from dba_data_files where tablespace_name='MY_TS'; FILE_ID AUTOEXTENSIBLE INCREMENT_BY 19 YES 65536
The documentation says that the increment_by is the "Number of Oracle blocks used as autoextension increment" therefore 8192*65536=512M, that's ok.
However by big import the alert.log flooded by messages like this