Slow activation with version 4.5 (4222462)
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
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Sign In Now
© 2022 Quest Software Inc. ALL RIGHTS RESERVED.