Determine number of times a datafile has extended

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 25 Sep 2001 00:26:58 -0700
Message-ID: <F001.00397448.20010925001025@fatcity.com>

Is it possible to determine how many times a file has extended?

I know that v$datafile.CREATE_BYTES will show what size the file was initially created at.
And dba_data_files.INCREMENT_BY shows how much each datafile is currently set to extend by (number of database blocks).

But, given that we can manually resize a file and that we can alter the value of next for a datafile, does Oracle store how many times each file has extended?

Why is this of interest - this number can be related to / help explain the degree of OS fragmentation for the datafile.

Thanks,
Bruce Reardon
--

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

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

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 Tue Sep 25 2001 - 02:26:58 CDT