Apply process is very slow
400137Jan 6 2006 — edited Jan 30 2006I was testing Oracle Streams from one source (DB1) to two destination databases (DB2 and DB3).
I have only one table to replicate from source to the destination databases
I inserted 1,000,000 records in this table.
But, after 15 hours they still are not in the destination databases.
Propagation process is over, I can check it.
He problem is in Apply process at the destination databases.
From all metrics statistics in OEM, I found strange results for Total Number of Transactions applied.
I can see that no transactions are being applied, also 7001139 messages are being dequeued.
Where is the problem? Am I missing something? If I test it with few records it works fine.
I am using one capture process and separate propagation processes for each destination database.
I have one apply process for each destination database. Can I have more? Can it de-queue speed?
Thanks
Mike