deadlock detected while updating oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
deadlock detected while updating oracle table
Hi All,
Did any one faced this issue when updating data in oracle 9 table using oracle enterprise stage?
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
Did any one faced this issue when updating data in oracle 9 table using oracle enterprise stage?
sqlcode is: -60
esql complaint: ORA-00060: deadlock detected while waiting for resource
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 48
- Joined: Sat Oct 22, 2005 9:56 am
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
Is this sateeshbabu mandepudi?
Well i changed to sequential mode. just to sack for work and it works.
But the real question remains is why parallel updatation doesn't work?.
is this something underlying database doesn't support it?
I have four nods and everything DBA comes and says datastage tried to update the table four times and got locked itself!
Well i changed to sequential mode. just to sack for work and it works.
But the real question remains is why parallel updatation doesn't work?.
is this something underlying database doesn't support it?
I have four nods and everything DBA comes and says datastage tried to update the table four times and got locked itself!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I've had the same issue lately and DBA's are stumped. INITRANS are increased on the table and the index. With commit set at 5000 and 4 nodes, always have the issue. I've set commits to 4, then to 10 and it keeps running ok. It seems to be a matter of keeping sessions on the nodes out of each other's way by making them commit more often. I can't say this will work every time in every environment (dev, qa, prod). But, at least I'm running more nodes than 1 and performance is better than on 1 or server, albeit not great performance.
Duplicate warnings
Hi,
Iam getting a warning in Lookup stage like,
"Lookup: Ignoring duplicate entry at table record 9; no further warnings will be issued for this table"
Iam trying to get n links from same copy stage and hence ends up with this warning.
Any solution for removing this warnings.
Thanks.
Iam getting a warning in Lookup stage like,
"Lookup: Ignoring duplicate entry at table record 9; no further warnings will be issued for this table"
Iam trying to get n links from same copy stage and hence ends up with this warning.
Any solution for removing this warnings.
Thanks.
Gopinath