My Oracle Support Banner

Resolve TimesTen Long Running Transaction Created From "S" Lock On Plan Table From Uncommited SELECT Statement (Doc ID 1483656.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version and later
Information in this document applies to any platform.
*** Check for Currency on 15-Feb-2016 ***


NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem discussed in this note.

Following long running transaction is observed





To view full details, 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 a vibrant support community of peers and Oracle experts.