My Oracle Support Banner

Table Locks On Compressed Columns Preventing Concurrent INSERT, UPDATE, And/Or DELETE Operations Resulting In eErors, TT6003: Lock request denied because of time-out. (Doc ID 1573220.1)

Last updated on JUNE 05, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version to [Release 11.2]
Oracle Exalytics Software - Version to [Release 1.0]
Information in this document applies to any platform.


Exalytics User has create TimesTen database with tables that use compressed columns (compressed columns is a feature that is currently only licensed for use with Exalytics).

User would attempt to do multiple concurrent INSERT, UPDATE, and/or DELETE operations but would get:

[TimesTen][TimesTen ODBC Driver][TimesTen]TT6003: Lock request denied because of time-out

Details: LockWait[60000ms] Tran 19.25313 (pid 22024) wants X lock (from Sn)
on table TTEXA.MYCOMPRESSEDTABLE. But tran 20.10958 (pid 22128) has it
in Sn (request was Sn). Holder SQL ( ...




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.