OGG Classic Extract Runs Slower and AWR Shows Huge Execution Of SELECT nvl(iot_name, 'NULL')
(Doc ID 2317688.1)
Last updated on MARCH 08, 2022
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
OGG Classic Extract runs slower and AWR report shows huge execution of following sql
SELECT nvl(iot_name, 'NULL') FROM all_tables WHERE owner = :owner AND table_name = :object_name
Changes
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 |
Changes |
Cause |
Solution |
References |