Link to home
Start Free TrialLog in
Avatar of tonydba
tonydba

asked on

clear space

From here how we can clear space

oracle@pulars:/home[DEFAULT]:
===> df -g .
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd1           2.00      0.08   96%    56722    57% /home
ASKER CERTIFIED SOLUTION
Avatar of woolmilkporc
woolmilkporc
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It largely depends upon what is consuming your space.  I might begin with huge temporary files (logs, trace, reports, etc.); then go after smaller ones that are old.  Your Oracle alert, archive, and listener log(s) should be trimmed periodically for preventative maintenance.

Obviously, DO NOT drop the datafiles, redo logs, etc.

A simple search of the abundant linux documentation will give you the syntax of the find command.

Do you have any specific examples of potential problems?
Hi tonydba, your question is about making space available on the /home filesystem.

Are we right to assume that you have an Oracle database installed under /home or is it just that you have to clean some files? If it's just about files then Oracle Database would not be the right topic.
I haven't read above comments, but based on your question, you can find if any file(s) older than certain day can be delete. To do this use find command with rm.
i.e.

find /home/ \( -name '*.*' -mtime +45 \) -print -exec rm {} \;
Check what all files are consuming the most of the space

#find /home -xdev -ls | sort -nr -k 7 | head

accordingly you can do the needful..

TY/SA
Avatar of tonydba
tonydba

ASKER

thanks