Ora 00054 who is locking

SPID, S. PORT , S. Improve this answer. Community Bot 1 1 1 silver badge. Abey Tom Abey Tom 1, 1 1 gold badge 10 10 silver badges 5 5 bronze badges. However, in my case the root cause was ITL contention. We had smaller rows, so many of them gets packed into a single block. Header did not reserve enough space for ITL entries when all the the rows were locked simultaneously. David Aldridge David Aldridge Unfortunately that is not an option for me, since the code which does that is deep inside the framework we use.

Also we don't have the source code. I get the error ORA the source statement is not compatible with the destination statement. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Hi friend i try the solution what you have given. The main thing now i am working in oracle 10g ,username is scott My table was locked now i cant release Actually what my doubt means where and in what user i have to release the lock because i tried your solution in my default scott user…but i am not getting a good result.

How to activate my locked table with drop and truncating operations…. Regards A. You have 2 options restart the sid or find the session with the lock on this table and kill it. No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy.

Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Anonymous January 20, 0 Comments.

As you see, any session that has referenced the table will require an "exclusive" lock, and always when you attempt a structural change such as adding or deleting columns. You have choices for avoiding the ORA error:. Re-run the change late at night when the database is idle. Do all DDL during a maintenance window with all end-users locked-out. Kill the sessions that are preventing the exclusive lock. If you don't want to write your own script, you can use the Oracle script collection for this, highly recommended because of the complexity of the locking structures.

Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.