Experience XLA slowness when using sysdate under typemode=0
Last updated on FEBRUARY 27, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 18.104.22.168.5 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