Friday, February 10, 2012

ORA-00054: resource busy and acquire with NOWAIT specified

November 23, 2010 by · Leave a Comment 

A you are working on a busy database than you will often see this error.

Description

It means that your session is trying to update an ob

Killing Locked Sessions in Oracle

November 5, 2009 by · 2 Comments 

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 [...]