dbms_job not responding for any call - broken, run etc.
Hi All,
Source database is 11g, with PRIMARY KEY Based MV Logs, on total about 40 tables.
I have fairly simple MVs with select columns from the tables, in 2 seperate instances of the Oracle 11g.
Server A is on the local network doing replication via db_link.
Server B is on remote site, so replication is under db_link + SSH.
I noticed that on both servers jobs gets stuck and wont run. Refresh is set to occur every 15 minutes during development.
I issued dbms_job.interval for every 24 hour refresh, and the calls seem to freeze and not come back.
I issued dbms_job.broken to set it to TRUE and then modify interval, those calls also seem to freeze.
0