Each refresh interval has two connections on 11.2.2.8.11 (Doc ID 2136996.1)

Last updated on MAY 12, 2016

Applies to:

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

Symptoms

2 processes of the same PID and refresh interval, with the same name on ttStatus output:
In: 11.2.2.8.10

Data store /u03/timesten/data/cachedb
There are 18 connections to the data store
Shared Memory KEY 0x29006cae ID 98305
PL/SQL Memory KEY 0x2a006cae ID 131074 Address 0x7fa0000000
Type PID Context Connection Name ConnID
Cache Agent 2366 0x00007f15f0014990 BMReporter(-1335281920) 4
Cache Agent 2366 0x00007f15f4014a90 Marker(-1332762880) 5
Cache Agent 2366 0x00007f15f8015810 LogSpaceMon(-1330657536) 8
Cache Agent 2366 0x00007f15f8157420 Refresher(S,5000) 6 ==> first connection for interval 5s
Cache Agent 2366 0x00007f15f8224ab0 Refresher(S,5000) 7 ===> second connection for interval 5s.

But on 11.2.1.9.10:

Data store /u03/timesten/1121/cachedb
There are 15 connections to the data store
Shared Memory KEY 0x0600998c ID 229377
PL/SQL Memory KEY 0x0700998c ID 262146 Address 0x7fa0000000
Type PID Context Connection Name ConnID
Cache Agent 2383 0x00007fdc4c06d7f0 BMReporter(1740187392) 4
Cache Agent 2383 0x00007fdc58014290 Timer 3
Cache Agent 2383 0x00007fdc60091cf0 Refresher(S,5000) 5 ===> only one connection for interval 5s
Cache Agent 2383 0x00007fdd08068e50 Handler 2

 

 

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