Re: Autoextend - where in the data dictionary ?

i don't know if this will help or not, but on hp-ux, i use a command like " du -k " to get the space used by every directory and file. if AIX has a similar facility, you could save the output to a file, and then diff (to eliminate duplicate lines) the output files, to narrow down the directory and files that are changing size.

this behavior seems very curious, and downright disturbing. i'd be very interested in what you find out. good luck.

"Neil Cudd" <neil_at_cudd.demon.co.uk> wrote in message news:980518525.4967.0.nnrp-10.c2de6f3d_at_news.demon.co.uk...
>
> Spencer wrote in message ...
> >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).
> >
>
>
> This is an SAP installation, so the filesystems are set up fairly well
> (i.e - data is kept away from indices and dump and trace files are on
> separate devices).
>
> I took a snapshot of the filesystem usage (df -k) and then did the same
> thing 3 hours later. The space is definitely being 'eaten' away, not
 rapidly
> but enough to cause problems down the way ....
>
> There are no other files apart from Oracle datafiles and autoextend is
> definitely not switched on for any file in the database.
>
> Anybody out there have Oracle V7.3.4.4 running on AIX 4.3.3 ? I'm
 suspicious
> of the os ....
>
> Neil c.
>
>
>
>
>
Received on Sat Jan 27 2001 - 14:14:56 CST