Hi Managers, Thank-you all for response. yesterday evening we took downtime and restarted the database that fixed the problem. It is better to install lsof to check which process is using that file. I still need to install that utility . Thanks, Srini The DBA may have to restart the database. The deleted file space will not return unitl the database, or whatever process that has it open, closes the file. One way to determine which process still has it open is to use 'lsof'. You can download it from www.sunfreeware.com. There are lots of options but a quick-n-dirty w/o RTM is 'lsof|grep -yourfile-'. Regards, -- Reggie Beavers __________________________________ Do you Yahoo!? All your favorites on one personal page Try My Yahoo! http://my.yahoo.com _______________________________________________ sunmanagers mailing list sunmanagers@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagersReceived on Thu Jan 13 17:13:51 2005
This archive was generated by hypermail 2.1.8 : Thu Mar 03 2016 - 06:43:42 EST