The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
693 views

ORA-02049 and ORA-02063 Errors

Select For UPDATE NOWAIT is performed on a table by 20 processes in parallel The error below is returned by the 4 processes out of 20 (16 processes are successful) SQL_UPDATE_ERROR- : SQL update ...
2
votes
1answer
88 views

Oracle user locks (dbms_lock): guaranteed order of requests granted?

I was wondering if Oracle guarantees that the sequence of dbms_lock.request granted is the same as the sequence in which they were requested. In my tests it always was the case, but I couldn't find ...
0
votes
0answers
6 views

Waiting for table level lock - Info says NULL> What could be causing this lock?

This is from one of our Slave servers in a master-slave replication setup. What could be causing the locak mentioned in the 2nd line? Under info it shows only NULL. And it does not have anymore info ...
0
votes
0answers
903 views

Oracle Transaction recovery: lock conflict caught and ignored

In alert log there are a lot of "Transaction recovery: lock conflict caught and ignored" statements. I've found some information, that this error is caused when there is an active dead transaction. ...