Databases can have tables of varying sizes ranging from very small tables to the tables of the size of tens of GB or more. The question arises as to whether there is a limit to the size of a table that can be replicated by Shareplex.
General information.
There is no limit as to the size of the table replicated by Shareplex. The only limiting factor is the size of the table allowed by the underlying database engine, namely Oracle (as of now). The upper limit of the quantum of transactions replicated by Shareplex may be governed by several factors including, but not limited to, resource availability on the server in question, Shareplex and database tuning on source and target, disk I/O tuning, etc. This may be the only limitation.
When replicating extremely large tables, there are some factors to consider:
1. The activation time is a function of the size of the table(s) to be activated. Supplemental logging can speed up activation.
2. Not all sync methods are suitable for very large tables, so dealing with out of sync condition may need special consideration. Some of the suitable choices include compare with "where" clause if feasible, Oracle Export/Import or Copy, resync of complete database using hotbackup with reconcile, etc.
3. To speed up replication of very large tables, it is advisable to have indexes on source and target for such tables.
