Timesten Datastore loads Very Slowly on IBM AIX systems
(Doc ID 1354237.1)
Last updated on FEBRUARY 27, 2019
Applies to:
Oracle TimesTen In-Memory Database - Version 7.0.5.12.0 and laterIBM 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
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
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
size inuse free pin virtual
memory 35389440 35365790 23650 5460451 30459809
pg space 35782656 1587528
showing 23mb free.
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |