Saturday, February 26, 2011

Shut Down Database - Takes Long

Ever wondered why the database takes a long time to shutdown after issuing "shutdown immediate".
This happens because there are Local connections to the database which are idle and waiting to get served. Issue the following command from a different session to get a Normal shut down.

ps -fu username | grep LOCAL=NO | awk '{print $2}' | xargs kill -9

No comments: