Re: logminer read rate

Posted by Roshan on May 31, 2021; 7:44am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/logminer-read-rate-tp9605p9821.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