Re: How to tell if autoextend is set on for a datafile

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

"Peter Shankey" <shankeyp_at_charlestoncounty.org> wrote in message
news:39DFC090.7AED81C0_at_charlestoncounty.org...


> What view shows where or not autoextend is set for a data file and what

> the various values are?

>

> Thanks

> Pete

>