Oracle 10g provide the “drop database” to drop the database.
startup mount exclusive restrict;
The command does clean up the files except the parameter files ( I use init.ora not the spfile. ) and password file.
After the database is drop, the oracle instance is shutdown. You can use ps –ef to grep the ORACLE_SID and you will see the processes are no longer exist.