Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DROP TABLESPACE and SPACE RELEASE in Linux

625135Feb 26 2008 — edited Mar 7 2008

Hello All,

I am using a two node RAC (RHEL4, x86_64 - OCFS2) and the problem I have been facing may be with non-rac too. I have dropped a tablespace including contents and datafiles. The tablespace is dropped and file is removed from the system, however the space is not yet released to OS.

Using "lsof" I see the deleted file is flagged as "(deleted)" and cross-checking the process in the oracle I see the process is in "jobq slave wait" with active session. I the OS will not recover the space and show the actual space unless this session is cleard.

Is there any way to trace this session and check which job is it being used?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 4 2008

Added on Feb 26 2008

#performance-availability, #real-application-clusters

8 comments

1,676 views