Database Tuning (MOSC)

MOSC Banner

ORA-00060 Cyclical Deadlock with 1 process only, using dbms_snapshot.refresh 11g

edited Jan 19, 2012 12:50AM in Database Tuning (MOSC) 6 commentsAnswered
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)

------------------------------
SQL Command (run on the snapshot server) :
------------------------------

SQL> execute dbms_snapshot.refresh('MYTABLE','F');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center