Table Locks On Compressed Columns Preventing Concurrent INSERT, UPDATE, And/Or DELETE Operations Resulting In eErors, TT6003: Lock request denied because of time-out.
Last updated on NOVEMBER 04, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 11.2]
Oracle Exalytics Software - Version 188.8.131.52.0 to 184.108.40.206.0 [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:
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 ( ...
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