My Oracle Support Banner

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

Last updated on JULY 28, 2020

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.