Does anyone have any insight how GG integrated replicat uses stream_pool?
I have seen quite often when doing update, the replicat is extremely slow, and trace file shows it couldn't free enough streams pool.
I have only one replicat running. Initially I allocated 5G stream pool, when i found this, I increased to 8G and eventually 12G. But it seems no matter how much i give streams_pool, that "apply shared t" take it immediately and rarely released it. I have open SR to Oracle, but received no good help at all.
Any one has similar experience? How do I understand the "apply shared t" part of streams_pool? Thanks.
-- trace file
knanrplcr: WARNING couldn't free enough streams pool
knanrplcr: size = 12884901888, cca_alloc=11476230088, msgbody_allc=0
knanrplcr: msghdr_alloc=616
----streams pool usage (not related to the above trace file, the one that related to the above trace file showed "apply shared t" close to 11G, and free memory 1g.)
2 streams pool free memory 4425987160
2 streams pool apply shared t 7932458640