If there are obsolete objcache files that are occupying space in SP_SYS_VARDIR/state, how do I clean these up?
Too many objcache files in the state directory.
NOTE: This procedure is to delete only objcache files. It does not apply to any other cache files.
Object cache files gets generated on the source upon activation, it is stored in vardir/state directory. If the object cache files are taking too much space on system, you can delete the older object cache files.
You can find the current object cache by querying the shareplex_actid table:
select actid from shareplex_actid; suppose it returns 32.
Each of the object cache file name contains the actid, it ends with the corresponding actid of the active config,.
o.SID-objcache_sp_conf.32
o.SID-objcache_sp_ocap.32
o.SID-objcache_sp_ordr.32
Note: PLEASE delete objcache files less than the current act id (this case < 32).
