Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure failing with ORA-04021: timeout occurred while waiting to lock object

Sunny86Jun 1 2021

Hello Experts
Oracle 12c
Procedure failing with ORA-04021: timeout occurred while waiting to lock object . Checked the locked objects and found the table under DDL_Lock table(dba_ddl_locks).
image.png
We have disconnected above session using
alter system disconnect session '2463.11504' immediate

Status session in V$Session is now killed

image.png

Still the lock is present and unable to run the procedure or truncate the table.

:(...
Comments
Post Details
Added on Jun 1 2021
3 comments
1,245 views