Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Autoextend - where in the data dictionary ?

Re: Autoextend - where in the data dictionary ?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 26 Jan 2001 14:22:34 -0000
Message-ID: <980519259.5290.0.nnrp-10.c2de6f3d@news.demon.co.uk>

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 ... Received on Fri Jan 26 2001 - 08:22:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US