6 Replies Latest reply: Feb 15, 2013 5:14 AM by oraman RSS

    how full must be tablespace for autoextend

    oraman
      hi 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...