RAM Loading A TimesTen Database (ttAdmin -ramload) On Linux Is Very Slow (Doc ID 1068882.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1.3.0 and later
Generic Linux
***Checked for relevance on 03-Jan-2014***

Symptoms

Loading a datastore into memory is taking a very long time.

In ttmesg.log you can see that initially it was fast but it has slowed down a lot.

For example:
09:55:35.30 Info: : 7074: 7078/0xd215570: Attempting restart from file 0
09:55:35.30 Info: : 7074: 7078/0xd215570: Checkpoint type = new fuzzy
09:55:35.30 Info: : 7074: 7078/0xd215570: ckptVNo = 2922
09:55:35.30 Info: : 7074: 7078/0xd215570: ckptLSN = 1145.47012232
09:55:35.30 Info: : 7074: 7078/0xd215570: undoLSN = 1145.47011840
09:55:35.30 Info: : 7074: 7078/0xd215570: Reading checkpoint file 0; data segment = 60285.2 mb (note: may be less than permsize)
09:55:45.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 3947.8 mb read in 10 sec (394.8 mb/sec); 56337.5 mb remain, estimate completion in 142 sec
09:55:55.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 8147.2 mb read in 20 sec (407.4 mb/sec); 52138.0 mb remain, estimate completion in 127 sec
09:56:05.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 12420.2 mb read in 30 sec (414.0 mb/sec); 47865.0 mb remain, estimate completion in 115 sec
09:56:15.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 16698.5 mb read in 40 sec (417.5 mb/sec); 43586.7 mb remain, estimate completion in 104 sec
09:56:25.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 20807.0 mb read in 50 sec (416.1 mb/sec); 39478.2 mb remain, estimate completion in 94 sec
09:56:35.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 24734.0 mb read in 60 sec (412.2 mb/sec); 35551.2 mb remain, estimate completion in 86 sec
09:56:45.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 28745.0 mb read in 70 sec (410.6 mb/sec); 31540.2 mb remain, estimate completion in 76 sec
09:56:55.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 32712.2 mb read in 80 sec (408.9 mb/sec); 27573.0 mb remain, estimate completion in 67 sec
09:57:05.00 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 36533.0 mb read in 90 sec (405.9 mb/sec); 23752.2 mb remain, estimate completion in 58 sec

...

09:58:07.30 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41144.0 mb read in 152 sec (270.7 mb/sec); 19141.2 mb remain, estimate completion in 70 sec
09:58:20.16 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41144.2 mb read in 165 sec (249.4 mb/sec); 19141.0 mb remain, estimate completion in 76 sec
09:58:31.31 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41145.0 mb read in 176 sec (233.8 mb/sec); 19140.2 mb remain, estimate completion in 81 sec


...

10:34:28.84 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41413.0 mb read in 2332 sec (17.8 mb/sec); 18872.2 mb remain, estimate completion in 1062 sec
10:35:19.12 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41413.2 mb read in 2384 sec (17.4 mb/sec); 18872.0 mb remain, estimate completion in 1086 sec
10:35:52.29 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41414.5 mb read in 2417 sec (17.1 mb/sec); 18870.7 mb remain, estimate completion in 1101 sec
10:36:03.73 Info: : 7074: 7078/0xd215570: Checkpoint file read status: 41487.5 mb read in 2428 sec (17.1 mb/sec); 18797.7 mb remain, estimate completion in 1100 sec

Changes

HugePages have been configured on the system.

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