Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center