TT_ROWLOCK(0) In Timesten Gives No Data (Doc ID 2128577.1)

Last updated on APRIL 27, 2016

Applies to:

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

Symptoms

When we are running query with below TT_ROWLOCK(0) hint  on TimesTen  it returns no Data and in oracle it returns data. In the exalytics system this hint need to be used.

Ex:

select /*+ TT_ROWLOCK(0) TT_TBLLOCK(1) TT_MERGEJOIN(0) TT_NESTEDLOOP(1) TT_FASTPREPARE(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