Try to find out the cause of such abnormal locking behaviour. Killing the session or shuting down DB will erase all evidence