Very Computer

by **Peter Shanke** » Sun, 31 Dec 1899 09:00:00

What view shows where or not autoextend is set for a data file and what
the various values are?

Thanks
Pete

by **Howard J. Roger** » Sun, 31 Dec 1899 09:00:00

V$datafile will show you the difference between what each datafile was
created at, and what it is currently sitting at (so it will show you the
effect of manual re-sizing, too).

But the real view you're after is dba_data_files, which has a column headed
"AUT" (ie, 'autoextensible'), as well as columns for Maxbytes and Maxblocks,
plus one for 'Increment By' -ie, the 'next' parameter in the autoextend
clause.

Regards
HJR
--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources: http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

Quote:> What view shows where or not autoextend is set for a data file and what
> the various values are?

> Thanks
> Pete

by **Peter Shanke** » Sun, 31 Dec 1899 09:00:00

I'm sorry I should have said that this is a 7.3 database. I did find all the
info for a 8.0 and above.

> V$datafile will show you the difference between what each datafile was
> created at, and what it is currently sitting at (so it will show you the
> effect of manual re-sizing, too).

> But the real view you're after is dba_data_files, which has a column headed
> "AUT" (ie, 'autoextensible'), as well as columns for Maxbytes and Maxblocks,
> plus one for 'Increment By' -ie, the 'next' parameter in the autoextend
> clause.

> Regards
> HJR
> --
> --------------------------------------------------------------------------
> Opinions expressed are my own, and not those of Oracle Corporation
> Oracle DBA Resources: http://www.geocities.com/howardjr2000
> --------------------------------------------------------------------------

> > What view shows where or not autoextend is set for a data file and what
> > the various values are?

> > Thanks
> > Pete

--
Pete Shankey

by **Connor McDonal** » Sun, 31 Dec 1899 09:00:00

> I'm sorry I should have said that this is a 7.3 database. I did find
> all the info for a 8.0 and above.

> V$datafile will show you the difference between what each
> datafile was
> created at, and what it is currently sitting at (so it will
> show you the
> effect of manual re-sizing, too).

> But the real view you're after is dba_data_files, which has
> a column headed
> "AUT" (ie, 'autoextensible'), as well as columns for
> Maxbytes and Maxblocks,
> plus one for 'Increment By' -ie, the 'next' parameter in the
> autoextend
> clause.

> Regards
> HJR
> --
> --------------------------------------------------------------------------

> Opinions expressed are my own, and not those of Oracle
> Corporation
> Oracle DBA Resources:
> http://www.geocities.com/howardjr2000
> --------------------------------------------------------------------------

> message

> > What view shows where or not autoextend is set for a data
> file and what
> > the various values are?

> > Thanks
> > Pete

> --
> Pete Shankey

sys.filext$

(If this table is not there, then nothing is in autoextend mode)

HTH
--
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me...
its the voices in yours.

Very Computer

How to tell if autoextend is set on for a datafile

How to tell if autoextend is set on for a datafile

How to tell if autoextend is set on for a datafile

How to tell if autoextend is set on for a datafile

How to tell if autoextend is set on for a datafile