Re: Autoextend for datafiles...

On 18 Sep 2000 21:59:21 GMT, K.Grant_at_nowhere.com.au (Kevin Grant) wrote:

>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.

Ah!
Now I see (said the blind man).
In that case - havn't got a clue.
You could of course run a job to update a NEW table with file information and then weekly/daily extract reports off it to see what has changed.
But then, you're probably busy enough eh?

L8R Received on Thu Sep 21 2000 - 00:00:00 CDT