Re: Autoextend - where in the data dictionary ?

Another good one is df -k | sort -n -r | more This will give you the largest files first.

Liz

In article <3%Fc6.16$Pn.4923_at_nnrp1.sbc.net>, spencerp_at_swbell.net says...
> 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 Tue Jan 30 2001 - 15:17:54 CST