Timesten Datastore loads Very Slowly on IBM AIX systems (Doc ID 1354237.1)

Last updated on SEPTEMBER 07, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 7.0.5.12.0 and later
IBM AIX on POWER Systems (64-bit)
IBM AIX on POWER Systems (32-bit)

Symptoms

Customer ran into an issue where the loading of the TimesTen datastore was very slow. The ttmesg log file showed the difference in timestamp of > 1hour. Here are the ttmesg log entries indicating the slow load time period:



2011-08-03 11:58:59.78 Info: : 991326: 495996/11021add0: Checkpoint file read complete: 84211.7 mb read in 1589 sec (53.0 mb/sec)

2011-08-03 13:02:58.90 Warn: : 991326: 495996/11021add0: Recovery started


procstack of the timestensub daemon doing the datastore ram load has the following stack trace snippet:


0x09000000036c3ffc sbSpinLatchInit() + 0x30
0x0900000003ac233c sbDbLatchesInit() + 0x164
0x09000000037a93b8 sbDbConnect() + 0x1420
0x09000000036a6514 sb_dbConnect() + 0x144
0x0000000100004a6c do_manage() + 0x620
0x0000000100002278 daHandler() + 0x214
0x000000010000c230 handlerThread() + 0x650
0x090000000047d4ec _pthread_body(??) + 0xdc



At the time of the problem, this is the output of svmon -G:


$svmon -G
size inuse free pin virtual
memory 35389440 35365790 23650 5460451 30459809
pg space 35782656 1587528



showing 23mb free.

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