My Oracle Support Banner

Why is my VAM or other extract slow or hung or not checkpointing? (Doc ID 1490270.1)

Last updated on JANUARY 13, 2022

Applies to:

Oracle GoldenGate - Version to [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.

touch ./dirtmp/junk

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 transmem directory has been created


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.