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 126.96.36.199.0 to 188.8.131.52.0 [Release 11.2]
Oracle Exalytics Software - Version 184.108.40.206.0 to 220.127.116.11.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
Million Knowledge Articles and hundreds of Community platforms