HOWTO : Understand Why TimesTen JDBC and ODBC Connections Always Acquire IX Database Lock (Doc ID 1567177.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

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

Goal

A customer observed that all SqlDeveloper connections to TimesTen acquired an "IX Database"  lock, and also observed
that this behavior was different from ttisql. The customer inquired if there was any way to avoid this lock. 

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