-
Title
Reconcile too slow on version 7.5 -
Description
Reconcile too slow:
1. With top/topas output, it is spending CPU time.
2.With truss/tusc/strace 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
kwrite(29, " P R O V I D E R\0\0\0\0".., 102400) = 102400 -
Cause
Reconcile is processing Table DDLs, and updating Post objcache file.
When Checking source event_log, there should be lots of auto-adding table operation.
<
[p570wgd1][/dsg/splex/vardir/2200/log]$grep 'has been added' event_log|wc -l
40512
> -
Resolution
These tables must be temporary tables,
1.disable auto-add function,
set param SP_OCT_AUTOADD_ENABLE 0
stop/start capture
Or
2.exclude these tables in config file(which should be wildcard)
For example, "expand user.% not (t_temp%) user.%"