Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Autoextend - where in the data dictionary ?
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