Re: Autoextend for datafiles...

From: RikH <rik_at_nowhere.man>
Date: Mon, 18 Sep 2000 05:55:22 GMT
Message-ID: <39c5ae00.288864718@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$

Column Name                    Null?    Type
------------------------------ -------- ----
FILE#                          NOT NULL NUMBER
MAXEXTEND                      NOT NULL NUMBER
INC                            NOT NULL NUMBER

The data's in DB blocks by the way.

L8R Received on Mon Sep 18 2000 - 00:55:22 CDT