Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Filesystem space not free'd up

BR679401
Occasional Visitor

Filesystem space not free'd up

Hi

An Oracle database file was moved out from one filesystem to another.The space required from the removal of the dbf file was not free'd up.What could be the problem
3 REPLIES
Robert-Jan Goossens
Honored Contributor

Re: Filesystem space not free'd up

Hi Andrew,

I'm not sure but I think you are using HP/UX.

If so,

login as root on the server,

locate the filesystem,

# bdf | grep filesystem

# fuser -c filesystem

will let you know if there are any processes holding the filesystem occupied.

# ps -ef | grep pid

will let you know the kind of proccesses.
Probably oracle proces.
If possible shut and start oracle database, this will most likely free up your space.

Robert-Jan.
CA538024
Honored Contributor

Re: Filesystem space not free'd up

Hi Andrew,

If you are using HP-UX, you might consider posting a question in the HP-UX section of the ITRC forums. Here's a link to that site:

http://forums.itrc.hp.com/cm/FamilyHome/1,,117,00.html

Please note that the same User ID and password you use on these forums work there as well.

Thanks and good luck!

Kathy
Forum Manager
CA188158
Honored Contributor

Re: Filesystem space not free'd up

Just because you deleted the file does not mean that it is gone.

If the file was in use by a process, then it will be deleted when all users free the file descriptor. It is just marked for deletion if it is still in use.

A good way is to put the machine in single user mode, or just reboot.
It is always a good day when you are launching rockets! http://tripolioklahoma.org, Mostly Missiles http://mostlymissiles.com