Slow activation with version 4.5 (28787)
Slow activation with version 4.5
Action was done to remove a table from replication and it was very slow. Shareplex seems to be hanging on the following query:
FROM SYS.dba_tablespaces dts,
WHERE dts.tablespace_name = ts.NAME
AND ( (tp.obj# = :1 AND tp.ts# = ts.ts#)
OR (sp.obj# = :1 AND sp.ts# = ts.ts#)
ran the above query in SQLPLUS substituting object_id for :1, returned value was NULL.
trace_log is showing the following:
02/16/07 13:40 Debug: FindUnusedCols for objectid 169962 [sp_tconf(osp)/25512]
02/16/07 13:40 Debug: Oracle error 1403 for CheckForAutoSegTab. Indicates partitioned table. [sp_tconf(osp)/25512
Slow activation on 4.5 due to removing heavily chained table.
Please download the patch called patch-18.104.22.1683.tar from:
There are a couple of fixes in 4.5.6 related to SEGMENT SPACE MANAGEMENT AUTO
This patch fixes the following:
 A problem when activating a table with chained rows that fails to clean up the SHAREPLEX_ROWIDMAP when the table is removed from replication.
Issue fixed in version 5.3.x. The latest version of Shareplex can be downloaded at: https://support.quest.com/shareplex/download-new-releases
© 2020 Quest Software Inc. ALL RIGHTS RESERVED.