| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Autoextend - where in the data dictionary ?
I'm currently administering various databases running Oracle 7.3.4 and 7.3.2 under AIX 4.3.3, and we are using Autoextend, so I have not seen your problem here. However, Oracle documentation recommends raw devices under Aix 4.3.3, but your observed behavior hints at JFS. Is the growth fast enough and big enough to be energetic journalling?
John Pye
"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message
news:3A742A84.4E30_at_yahoo.com...
> 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 ...
>
>
 |
 |