-
Title
Auto-add function and related performance problems -
Description
When lots of tables add or remove from replication, it may affect read and reconcile process:
1. May cause Reconcile too slow
1.Trace output: truss -d -o reconcile_trc.txt -p <reconcile pid>
There are lots of updating objcache operation,
<
kread(29, "\0\0\0\0\0\0\0 F I V R _".., 102400) = 84988
1.4799: close(29) = 0
1.4802: close(29) Err#9 EBADF
1.4805: close(29) Err#9 EBADF
1.4810: access("/oratest/splex/vardir/state/0x86400223+PP+p570wgd1+sp_opst+o.BOMC-o.ora10g-log_sp_opst_mt.3", 0) Err#2 ENOENT
1.4813: kopen("/oratest/splex/vardir/state/0x86400223+PP+p570wgd1+sp_opst+o.BOMC-o.ora10g-log_sp_opst.3", O_RDONLY) Err#2 ENOENT
1.4830: __semop(37748780, 0x2FED1FB0, 1) = 0
1.4834: klseek(6, 0, 4096, 0x00000000) = 0
kread(6, " S Q U E\0\0\002\0\0\0\0".., 2256) = 2256
1.4839: klseek(6, 0, 4096, 0x00000000) = 0
kwrite(6, " S Q U E\0\0\002\0\0\0\0".., 2256) = 2256
1.4845: klseek(5, 0, 0, 0x00000000) = 0
kread(5, " Q H D P\0\0\0\b\0\0\0\0".., 4888) = 4888
1.4851: klseek(5, 0, 0, 0x00000000) = 0
kwrite(5, " Q H D P\0\0\0\b\0\0\0\0".., 4888) = 4888
1.4879: __semop(37748780, 0x2FED1FB0, 1) = 0
1.4883: kopen("/oratest/splex/vardir/state/0x86400223+PP+p570wgd1+sp_opst+o.BOMC-o.ora10g-objcache_sp_opst.3-temp", O_WRONLY|O_CREAT|O_TRUNC, S_IRUSR|S_IWUSR|S_IRGRP|S_IROTH) = 29
1.4894: statx("/oratest/splex/vardir/state/0x86400223+PP+p570wgd1+sp_opst+o.BOMC-o.ora10g-objcache_sp_opst.3-temp", 0x363A94AC, 76, 0) = 0
1.4898: __libc_sbrk(0x00000000) = 0x3648DA40
kwrite(29, " O C A 5\0\0\v 絓0\0 ??.., 102400) = 102400
kwrite(29, "\0\0\0\0\0\0\0\0\0\0\0 A".., 102400) = 102400
kwrite(29, "\0\0\0\0\0\0\0\0\0\0\0\0".., 102400) = 102400
kw -
Cause
1.For reconcile,
Since there are too many auto-adding tables operation, which need to update objcache file.
2.For Read,
It caused ccache file become too big, and affect the performance.
-
Resolution
Need to exclude them from config file, or disable auto-add function in source.