Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: autoextent fo data files
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
![]() |
![]() |