logminer read rate downstream DB

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/logminer-read-rate-downstream-DB-tp9823.html

Hello Erman,

I have one downstream database which runs Oracle golden gate. Bith extract and replicat run on same server. I would like to do CDC using Striim from database on that server.

I see performance is very slow: it takes hours to replicate the change.

I checked the logminer read rate and most of the time is spent on the SQL client.

dware11_ora_8404_LOGMNR_TRACEnew.txt
Log read rate is 22G/h.


45 G archives generated per hour.

Kindly advise.

Regards,

Roshan