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 NOVEMBER 04, 2016
Applies to:Oracle TimesTen In-Memory Database - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11.2]
Oracle Exalytics Software - Version 22.214.171.124.0 to 126.96.36.199.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 ( ...
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!