Resolve TimesTen Error "waiting for latch "Index Index_name" When Observing Slow Performance With Hash Indexes (Doc ID 1669523.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 and later
Information in this document applies to any platform.
** Checked for Currency on 2nd Nov 2015 **

Symptoms

The following symptoms are encountered:

18:44:09.38 Warn:    : 25490: 25496/0xa666f00: ConnId=887 (Checkpoint) waiting for latch "Index Index_name"(2328744), Holder=13 (java) PID 27746, now 1 secs
18:44:17.26 Warn:    : 25490: 26453/0x1a635260: ConnId=21 (java) waiting for latch "Index Index_name"(2328744), Holder=13 (java) PID 27746, now 1 secs
18:44:23.05 Warn:    : 25490: 25659/0x19a90260: ConnId=1 (java) waiting for latch "Index Index_name"(2328744), Holder=13 (java) PID 27746, now 1 secs
18:44:30.04 Warn:    : 25490: 25659/0x19a90260: ConnId=1 (java) waiting for latch "Index Index_name"(2328744), Holder=13 (java) PID 27746, now 1 secs
18:45:35.19 Warn:    : 25490: 26782/0x13b66260: ConnId=19 (java) waiting for latch "Index Index_name"(2328744), Holder=13 (java) PID 31187, now 1 secs

Cause

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