Re: Autoextend - where in the data dictionary ?

Neil Cudd wrote:
>
> Ms. D.H. Harvey wrote in message <94rpee$sgl$1_at_news.liv.ac.uk>...
> >,Neil Cudd <neil_at_cudd.demon.co.uk> wrote:
> >: I have a weird problem :
 

> >: Oracle 7.3.4.4 on AIX 4.3.3
 

> >: out of the blue I started to get a load of ORA 376's (file offline).
 Checked
> >: the files and they had a status of recover. Checked Alert Log and there
 were
> >: a load of os level errors saying no space left on device. Checked
 filesystem
> >: and it's 100% full.
 

> >: Now I was able to get round this but I have checked (via enterprise
 manager)
> >: and the files are NOT aoutextend (I never like auto extend anyway). I'd
 like
> >: to check this in the data dictionary, but can't find the relevant view.
 It
> >: does seem like the file system space is being 'nibbled' away over time
 and
> >: I'm racking my brain trying think how !!
 

> >: Any suggestions greatly appreciated,
> >: Neil C.
> >
> >SYS table filext$
> >
> > FILE# File no refs to dba_data_files
> > MAXEXTEND Max size file can be (in blocks)
> > INC Extend increment size (in blocks)
> >
> >HTH Helen
>
> Thanks Helen. I've since found out that the sys.filext$ view is not created
> until one datafile is made autoextensible. So if the view doesn't exist, no
> files are on autoextend. The view doesn't exist in this database !
>
> curiouser and curiouser ...

mainly 'cos autoextend was 'new' in 7.3.x. Once you get to 8.x, then you'll an appropriate column in DBA_DATA_FILES

HTH

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

"Some days you're the pigeon, some days you're the statue"