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 and later
Information in this document applies to any platform.


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.


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