Oracle 9i autoextend

[Kalin Evtimov]

Hi!

Which table contains information about how big an increment for a datafile is, when datafile was set to autoextend?

Thank you!

[Yogeeraj_1]

hi,

dba_data_files

yogeeraj@MYDB.HOME.MU> desc dba_data_files
Name Null? Type
----------------------------------------- -------- ----------------------------
FILE_NAME VARCHAR2(513)
FILE_ID NUMBER
TABLESPACE_NAME VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
ONLINE_STATUS VARCHAR2(7)

yogeeraj@MYDB.HOME.MU> exec print_table('select * from dba_data_files where tablespace_name=''TBS_LARGE''')
FILE_NAME : /d01/oracle/oradata/mydb/tbs_large.dbf
FILE_ID : 25
TABLESPACE_NAME : TBS_LARGE
BYTES : 2803892224
BLOCKS : 342272
STATUS : AVAILABLE
RELATIVE_FNO : 25
AUTOEXTENSIBLE : YES
MAXBYTES : 34359721984
MAXBLOCKS : 4194302
INCREMENT_BY : 6400
USER_BYTES : 2802843648
USER_BLOCKS : 342144
ONLINE_STATUS : ONLINE
-----------------

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.70
yogeeraj@MYDB.HOME.MU>

hope this helps!

kind regards
yogeeraj

[spex · Accepted solution]

Hi Kalin,

SELECT file_id, file_name, tablespace_name, increment_by
FROM DBA_DATA_FILES
WHERE autoextensible='YES';

PCS