Why is my VAM or other extract slow or hung or not checkpointing?
Last updated on FEBRUARY 03, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.25 to 188.8.131.52.3 [Release 11.1.1 to 11.2]
Information in this document applies to any platform.
Identifying (though not unique) characteristics are/were that the read checkpoint was not moving, that any sends to and stops of the extract failed, and lag increased.
The definitive marker for this is that the transmem directory cannot be written to by the OGG user. Also, an ls -l of dirtmp returns no files.
For instance, the following will fail when executed by the owner of OGG.
This will fail if the specified directory has not been created and/or if the OGG user does not have write access to the specified directory.
The directory for transmem is specified, probably in a new extract, and s transmem directory has been created
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms