Veridata Agent Spinning At 100% CPU
(Doc ID 2329099.1)
Last updated on JULY 20, 2020
Applies to:
Oracle GoldenGate Veridata - Version 12.2.1.2.0 and laterInformation in this document applies to any platform.
Symptoms
Veridata agent spinning at 100% CPU
Trying to do the pair configuration pegs CPU at 100%
This happens when trying to select a specific schema from from datasource--
SELECT NULL AS table_cat,
o.owner AS table_schem,
o.object_name AS table_name,
o.object_type AS table_type,
NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE', 'VIEW')
ORDER BY table_type, table_schem, table_name
In this case,the database in questions returns over returns 120 000 objects.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |