Re: Autoextend - where in the data dictionary ?

are the archive log directory and/or admin directory on the same filesystem as the datafiles ? there are several files and directories (used by oracle) that grow over time. here are few places to check first:

archive log dest directory
udump directory (*.trc)
bdump directory (*.trc and alert_sid.log file) sqlnet.log
listener.log
audit directory (under $ORACLE_HOME)
export files
backup files

also verify that no other processes are using the oracle file system(s).

HTH "Neil Cudd" <neil_at_cudd.demon.co.uk> wrote in message news:980506701.26675.0.nnrp-12.c2de6f3d_at_news.demon.co.uk...
> 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.
>
>
>
Received on Fri Jan 26 2001 - 08:02:44 CST