Home > Default > Deadlock

Deadlock

November 30Hits:0
Advertisement
Dear all,
Can anyone help me to resolve deadlock.
we are repeatly getting deadlock error in alert log. i know oracle handles it automaticallly to resolve deadlock.
is their any way to avoid the same.
how to resolve ora-60 . deadlock ?
Regards

Answers

user13367819 wrote:
Dear all,
Can anyone help me to resolve deadlock.
we are repeatly getting deadlock error in alert log. i know oracle handles it automaticallly to resolve deadlock.
is their any way to avoid the same.
how to resolve ora-60 . deadlock ?
RegardsDeadlock is going to create a trace file and an entry in the alert log to tell you that it's there. Also, deadlock is NOT going to be created by oracle. If it's there, it means that your application developers have coded a wrong logic and thus are locking (trying to) each other and causing this error to come. To resolve this error, you need to check the application code of yours, there is nothing from the db level that you can do.
HTH
Aman....

Read other 4 answers

Tags:

Related Articles

  • Error-Code: ora-4020 Deadlock error, while updating a recordOctober 11

    Hello! Is it possible to get a deadlock error when two or more users try to update the same record simultaneously? And what would be the best solution to circumvent this? Thanks Your help is appreciated.<BLOCKQUOTE><font size="1" face=&

  • ORA-00060: Deadlock detectedOctober 11

    I getting error as "ORA-00060: Deadlock detected. More info in file /d01/oracle/VIS/db/tech_st/10.2.0/.................". Following are my observations on the occurence of this error. The deadlock is encountered first time when trying to login t

  • Print process deadlockOctober 11

    Hi All, <br/> <br/>We are now facing some problems on our smartform printing programs, sometimes some of the smartform programs look getting stuck, from SM50, the processing time is endless, and from the detailed tracing log, there are repeate

  • How to deal with deadlock on wwv_flow_data table when http server times outOctober 11

    There are some threads about a deadlock on the wwv_flow_data table. None of them contain a real explanation for this behaviour. In my case I will try to explain what I think is happening. Maybe it helps somebody who is hitting the same matter. In my

  • Max Degree of Parallelism, Timeouts and DeadlocksOctober 11

    We have been trying to track down some timeout issues with our SQL Server. Our SQL Server runs a AccPac Account System, an Internal Intranet site and some SharePoint Content DBs.   We know that some of the queries are complex and take some time, thou

  • Multiple threads block each other, but its not a deadlock!October 11

    I have recently upgraded to Berkeley 2.4.16/DB 4.6.21 on Linux 2.6.9-68.9.ELsmp #1 SMP 2008 x86_64 GNU/Linux Right away I noticed that when I run two threads, one doing a putDocument, another doing a query, they get stuck, as if they were deadlocked,

  • Deadlocks with ALTER TABLE DISABLE CONSTRAINTOctober 11

    Hello, We're deleting millions of redundant rows from a particular table in our live 10g database. This is being done online because the downtime would be unacceptable. The table in question has 30 child tables, so for speed I am disabling the foreig

  • Data Committed instead of Rollback after Deadlock Error in SQL Server 2008 R2 (SP2)October 11

    We're having a strange issue which is occurring only with one Customer having SQL Server 2008 R2 (SP2). Basically we have multiple threads uploading data and when an error occurs (like deadlock or any other error). The deadlock victim (process/transa

  • JDAPI Error: ORA-04020: deadlock detected while trying to lock objectOctober 11

    I have written a JDAPI program to perform read-only impact analysis and report any problems. The following error is occurring: "A deadlock among DDL and parse locks is detected. This deadlock is usually due to user errors in the design of an applicat

  • Database error"ORA-00060: deadlock detected while waiting for resource"October 11

    Hi All, I got dump as Database error text........: "ORA-00060: deadlock detected while waiting for   resource" Internal call code.........: "[RSQL/RDUP/NRIV ]" Please check the entries in the system log (Transaction SM21). An exception

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.676 s.