topic Re: Increased mount point size in Operating System - HP-UX

Increased mount point size

Fuad_1 — Sat, 14 Dec 2002 05:59:54 GMT

I have noticed that the /opt/app/oracle size is reaches 99% used. I want to know what are the files that are added or modified during the last days that causes this increase.

Re: Increased mount point size

T G Manikandan — Sat, 14 Dec 2002 06:18:38 GMT

#du -k /opt |sort -nr|more

find out the directories which are using more space.
and check out the files.

I would check for the .trc files.
I am not sure whether you have enabled the sql_trace in your oracle.

check your $ORACLE_HOME/dbs/init.ora file for the parameter
user_dump_dest=

Check for the .trc files in the destination directory and clean them up.

Revert

Re: Increased mount point size

Rajeev Shukla — Sat, 14 Dec 2002 06:30:57 GMT

Hi try using the newer option with the find command.
Example say you take a file name and want all files newer that that then just type

find ./ -newer
in the /opt/app/oracle directory.

One more suggestion you can use is -size option with find option to find the files of a particular size.

Cheers
Rajeev

Re: Increased mount point size

Rajeev Shukla — Sat, 14 Dec 2002 06:32:38 GMT

Re: Increased mount point size

Fuad_1 — Sat, 14 Dec 2002 09:01:35 GMT

please I want to know which files are updated recently..

Re: Increased mount point size

Rajeev Shukla — Sat, 14 Dec 2002 09:48:46 GMT

Fist is define how recent you need. Take that file and make it a refrence And the use the option
find /opt/app/oracle -newer

That will give you all files updated after this defined time.

Rajeev

Re: Increased mount point size

Robert-Jan Goossens — Sat, 14 Dec 2002 09:56:27 GMT

Hi,

How can files be identied that were created yesterday so they can be purged?
The "-mtime" option could be used, but it considers a day to be a multiple
of 24 hours. Therefore, it won't locate files created before midnight but less
than 24 hours ago. To accomplish this follow the following procedure.

RESOLUTION

1. Create a file to compare against. In this example we are looking for files
last modified on 12/21 or earlier.

touch -t 12220000 /tmp/compare

2. Create a script in /tmp called older.sh for the find command to execute.
Make sure it has execute permissions. It will be used to identify files older
than the compare file created in step 1. Older.sh can be modified to move or
purge the files as desired.

#!/usr/bin/ksh
COMPARE=/tmp/compare
if [ $1 -ot $COMPARE ]
then
echo File $1 is older than file $COMPARE
fi

3. Run the find command to identify the files.

find / -type f -exec /tmp/older.sh {} \;

Hope it helps,

Robert-Jan.

Ps.
https://www.beepz.com/personal/merijn/

A. Clay Stephenson's Date Hammer Shell version or Perl version
You can download it on Merijn's webpage.