Space not released while dropping Tablespace: LINUX
Some time I drop tablespace including contents and datafiles but the corresponding OS space is not released. A way to find the cause and solution is like below /sbin/fuser -cu mount_point_where_space_should_release you will then find an output like below mount_point: 4636(oracle) 13531(oracle) 16393(oracle) these are the processid(spid). So you can easily find the process detail (sid, program, schemaname etc) and kill accordingly. select P.SPID ,S.SID ,S.SERIAL#, S.SCHEMANAME, S.PROGRAM from v$process p, v$session s where P.ADDR=S.PADDR and spid in (4636,13531,16393); alter system kill session 'sid,serial#'; Normally you can kill the processes other than background process if they are not necessary. In my experience I found that dbsnmp user locked that session so the space isn't released.