Beautifully written about Oracle DB Session Locks, also check http://www.oracle-base.com/articles/misc/killing-oracle-sessions.php