ORA-00060 Cyclical Deadlock with 1 process only, using dbms_snapshot.refresh 11g
Hi,I am using the dbms_snapshot.refresh ('tablename','F') command on a lot of servers (replication between 2 distributed database)
It used to work well with 9i and 10g database.
I've now installed it on 6 servers with oracle 11.2.0.2
on 3 servers, I've got an error while refreshing the snapshot
I've looked at the faq on the oracle support, but didn't find how to understand deadlook with only one process involved
Here are the traces generated on the deadlock :
servers are windows X64 11.2.0.2
(original error messages where in french, I've translated it)
It used to work well with 9i and 10g database.
I've now installed it on 6 servers with oracle 11.2.0.2
on 3 servers, I've got an error while refreshing the snapshot
I've looked at the faq on the oracle support, but didn't find how to understand deadlook with only one process involved
Here are the traces generated on the deadlock :
servers are windows X64 11.2.0.2
(original error messages where in french, I've translated it)
------------------------------
SQL Command (run on the snapshot server) :
------------------------------
SQL> execute dbms_snapshot.refresh('MYTABLE','F');
0