Re: Autoextend for datafiles...

From: Kevin Grant <K.Grant_at_nowhere.com.au>
Date: 18 Sep 2000 21:59:21 GMT
Message-ID: <8FB458DADKGRANTBNEQLDAU@132.234.250.31>

rik_at_nowhere.man (RikH) wrote in <39c5ae00.288864718_at_news.ozemail.com.au>:

>On 18 Sep 2000 05:30:45 GMT, K.Grant_at_nowhere.com.au (Kevin Grant)
>wrote:
>
>>Does anyone know of a way to get information on how many times and by
>>how much a datafile has autoextended?
>>
>>The DBA_ views, etc don't have the info I'm after and I had a look in
>>the manuals but without success.
>>
>>Thanks for any help.
>>
>>Kev.
>
>
>Matey,
>
>
>SVRMGR> desc FILEXT$

Thanks Rik,

But this has the same information as DBA_DATA_FILES (ie: it only contains the maximum size that the datafile can autoextend to).

What I'm after is the date/time that a datafile has autoextended in the past.

Kev. Received on Mon Sep 18 2000 - 16:59:21 CDT