Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i autoextend

SOLVED
Go to solution
Kalin Evtimov
Regular Advisor

Oracle 9i autoextend

Hi!

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

Thank you!
2 REPLIES
Yogeeraj_1
Honored Contributor

Re: Oracle 9i autoextend

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
spex
Honored Contributor
Solution

Re: Oracle 9i autoextend

Hi Kalin,

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

PCS