Why does a large Update to a usermanaged cache group take minutes to propagate to Oracle?

(Doc ID 1605396.1)

Last updated on MARCH 02, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Goal

 The customer wants to use a usermanaged cachegroup which allows DML to be propagated from TimesTen to Oracle, and DML on Oracle to be autorefreshed to TimesTen. However an Update of 25,000 rows on Oracle completes in 7 seconds whereas against the  usermanaged cachegroup it takes 4 to 5 minutes

Solution

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