My Oracle Support Banner

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

Last updated on OCTOBER 08, 2023

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

The following symptoms are encountered:

  • Replication bookmark are advancing very slowly
  • Application performance in general also is slow
  • The follow sample ttmesg log entries are found
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

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.