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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy