Shareplex version 6.0 and 6.0.1.18 for Oracle 9i take long time to activate a configuration that has only one new table added into it.
Looking into the database, this is the query that has been executed for each table in the configuration file: SELECT DECODE(ALWAYS, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") FROM DBA_LOG_GROUPS where TABLE_NAME = :1 and OWNER = :2.
Whether the table has been replicating or not, that query will be executed. Therefore, Shareplex will spend large amount of time to execute that query when the configuration has many objects.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Shareplex for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center