Experience XLA slowness when using sysdate under typemode=0 (Doc ID 1917114.1)

Last updated on FEBRUARY 27, 2016

Applies to:

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

Symptoms

Customer is having XLA application which does something similiar to the following:

 

update table set lastupdate = sysdate where Id = 1;

 

When a row is updated, the timestamp is compared against the current system time to see what the delay is.    Customer found that when using typemode=1, there is no delay. When using typemode=0, there is 10 times the delay comparing to typemode=1.

Cause

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