IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

Tag Archives: distributed_lock_timeout

DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error

Mehmet Salih Deveci November 30, 2020 Oracle 0

I will explain the DDL_LOCK_TIMEOUT Parameter Usage to Avoid ORA-00054: resource busy error in this post. let’s review the DDL_LOCK_TIMEOUT Parameter | ORA-00054: resource busy error.

ORA-02049: timeout: distributed transaction waiting for lock

Mehmet Salih Deveci April 15, 2020 ORA-ERRORS 0

You can get ” ORA-02049: timeout: distributed transaction waiting for lock ” error during the drop any user.