RE: autoextent fo data files

From: Nguyen, Long <Long.Nguyen_at_its.csiro.au>
Date: Mon, 25 Sep 2000 10:52:30 +1100
Message-Id: <10629.117736@fatcity.com>

Thanks Adisekaran and Shreepad for the info.

Long

-----Original Message-----
From: Shreepad Vaidya [mailto:Shreepad.Vaidya_at_alltel.com] Sent: Friday, 22 September 2000 6:16 PM
To: Multiple recipients of list ORACLE-L Subject: 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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shreepad Vaidya
INET: Shreepad.Vaidya_at_alltel.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Sep 24 2000 - 18:52:30 CDT