As to what shutdown immediate|abort|transactional do, look here:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/start.htm#6370And immediate may take a lot of time - depending on how long the longest rollback will take. Someone on the Oracle newsgroup posted that he once waited 6 hours.