Killing Locked Sessions in Oracle Many a times user sessions are locked in some DML/DDL operation, than how to unlock those sessions because a new step or operation could not be done on the specific object that is locked.
Some really easy steps to unlock an object or kill a session in oracle are as follows:
To view locked sessions in oracle:
select oracle_username,object_id,session_id from v$locked_object;
ORACLE_USERNAME...
by Nauman at November 5th, 2009 at 12:11 am 
Subscribe to RSS