linux and oracle

Hi

Perhaps more a linux problem than oracle... Database is 10.2 and the system is a Red hat enterprise 3.4

What I did was deleteing alot of tablespaces (first drop the users and then the tablespace) which occupied 12gb of data and the files were deleted from the filesystem as expected, but the disk usage (with df) showed that the used space was still 100% but when examed with "du
--max-depth=1" it showed that it should have 12gb free.
When examined with lsof the deleted files where reported as opened (with the flag deleted at the end) and owned by the processes j000 and j000.

Waited almost an hour before i restarted the db and after that everything was ok.

Anyone knows what happened ( iahve done this many time before but never seen this) and if there is a cleaner way to resolve it?

/Johan
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 19 2007 - 07:44:36 CDT