Many a times customers are asked to provide the object cache files when troubleshooting issues. This solution delves on the description of what is contained in the object cache file.
General information.
The object cache file contains entries in it that are Shareplex's representation of the table structure. The object cache file is created on source and subsequently on target when the activation is done the first time. Subsequently, when there are supported DDL done on tables on source database, the object cache entry for the tables are updated. Moreover, when new tables are added to the existing replication by way of fresh activation on the top of existing activation, the object cache file gets updated as well with entries for newly added tables in replication. The object cache on target is updated when the message for object cache change traverses from source Shareplex to target via queues. The object cache file resides in the state subdirectory under the variable directory, the latter is also termed as vardir and is pointed to by the environment variable SP_SYS_VARDIR.
If the DDL is not a supported one, then the object cache on source and target is not updated. In this situation, the users need to take the table out of replication and then bring them back in replication. Moreover, if the DDL replication is disabled, then the object cache is updated on both source and target but the users need to apply the DDL on target table separately to update its structure.
