Re: golden gate replication table

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/golden-gate-replication-table-tp8191p8292.html

Hi Erman,

I have recreated the indexes. Replication is fine now :)

I have checked the doc below

https://casesup.com/category/knowledgebase/databases/how-to-analyse-swap-memory-usage-oracle-solaris

system does not seem to be short of memory.

ora12c@dware1:~$ /usr/bin/ps -e -o pid,rss,args|egrep 'sched|pageout|fsflush'|grep -v grep
    0        0 sched
    2        0 pageout
    3        0 fsflush
ora12c@dware1:~$ vmstat 1 5|awk '{print $8 " " $9}'

pi po
57 110
0 0
0 0
0 0
0 0
You have new mail in /var/mail/ora12c

ora12c@dware1:~$ vmstat 1 2
 kthr      memory            page            disk          faults      cpu
 r b w   swap  free  re  mf pi po fr de sr am s0 s1 s2   in   sy   cs us sy id
 0 0 72 136630312 9585608 1747 3014 57 110 96 0 2 9 225 63 5 17351 26533 33525 3 2 96
 0 0 209 138784288 8420592 117 5496 0 0 0 0 0 0 61 2 0 11850 17134 16135 2 1 97
ora12c@dware1:~

RSS is 0

I have also set SGA_MAX_SIZE in extract file to limit the memory used by logminer process for the extract. It seems fine now unlike before.

Thanks