Database Administration (MOSC)

MOSC Banner

Confusion with autoextend on datafiles

edited Feb 16, 2016 4:03AM in Database Administration (MOSC) 8 commentsAnswered

I always thought datafiles can grow to a max of 32 GB (one block less than 32GB to be precise). But for the following tablespace I am wondering how couple of files grew beyond that (more confusing is - one of them is with autoextend ON and another OFF). Any clarification or reference document in this regard will be greatly helpful.

SQL> select file_id, file_name, bytes/1024/1024/1024 SIZE_GB, autoextensible from dba_data_files where tablespace_name='FIHROBIIX01';

   FILE_ID FILE_NAME                                                                 SIZE_GB AUT

---------- ---------------------------------------------------------------------- ---------- ---

        13 /hradmuwlk1/oracle/dbdata/app02/ofihrix01.dbf                          63.9990234 YES

        14 /hradmuwlk1/oracle/dbdata/app02/ofihrix02.dbf                                  31 NO

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