Does lsof have to be run as root because I issued

lsof -u oracle

and it said command not found. Or does it have to be downloaded?

The alert log shows that the files associated to the dropped tablespace have been deleted.

So if the files have been deleted then surely something is stuck somewhere.