Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: autoextent fo data files

Re: autoextent fo data files

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Fri, 22 Sep 2000 1:15 -0500
Message-Id: <10626.117625@fatcity.com>


Hi,
Check for sys.filext$ ,dba_data_files and v$datafile

There is a column
 create_bytes in v$datafile ( size of file when created) bytes:------gives the current size.

The increment_by column in dba_data_files will give the size by which the data file is incremented.

          hope this helps.
                         Shreepad.
Received on Fri Sep 22 2000 - 01:15:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US