Wednesday, July 13, 2016

GoldenGate Datapump Network Tuning

when you configure these following parameters in pump parameter file, network transfer speed increases # 

compress: Compresses outgoing blocks of records to reduce bandwidth requirements. Again goldengate will decompresses the data before writing in to the trail. Compressing and Uncompressing data can consume CPU resources 

tcpbufsize: This will control the size of the TCP socket buffer. TCP socket buffer allows pumps to send larger size packets to the target system. 
For to calculate as follows 
( Avg round trip time (RTT) x Network Bandwidth per second ) / Bytes 

tcpflushbytes: controls the size of the buffer, in bytes that pump collects the data and send across the network 

rmthost tnc2.localdomain mgrport 7809, compress, TCPBUFSIZE 1048576, TCPFLUSHBYTES 1048576

--Nikhil Tatineni--
--Oracle In memory-- 

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...