Re: Autoextend - where in the data dictionary ?

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Fri, 26 Jan 2001 14:10:22 -0000
Message-ID: <980518525.4967.0.nnrp-10.c2de6f3d@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 Fri Jan 26 2001 - 08:10:22 CST