Category: TimesTen

TimesTen

TimesTen: Parallel Thread Reads from Checkpoint Files – More is not always better

I wanted to get around to to some performance improvements with Oracle TimesTen Database. As you know, the Oracle TimesTen database creates a checkpoint file for persistence of the In-Memory database. In the event you need to load the database into memory, depending upon the size of the checkpoint, this can take some time. In …

TimesTen

TimesTen: Failed to retrieve IP address of the system

In my quest to understand TimesTen a bit more, I built a VM with VirtualBox, OL 6.5, and TimesTen 11.2.2. I verified that I could connect to TimesTen from the VM instance, but when I tried to connect to the TimesTen database from my host (MacBook Pro), I received the following error:

I even tried …

Oracle, TimesTen

Oracle TimesTen not using Large Pages

 Oracle TimesTen Database, was not using Huge/Large pages. Well at least when I executed a ttStatus command, I saw the following: Shared Memory KEY 0x0c0504dd ID 1838710795 (LOCKED) when I expected to see Shared Memory KEY 0x0c0504dd ID 1838710795 (Large Pages,LOCKED)

My ttendaemon.options file was configured correctly (see snippet below): -linuxLargePageAlignment 2

Memory …

Oracle, SQLDev, TimesTen

SQL Developer with Oracle TimesTen ttStats

I’ve had the opportunity to work on with the TimesTen database on the Oracle Exalytics platform, and once again I got to use my favorite tool to make life so much easier. If you’ve ever used TimesTen, then the ttIsql command line should be familiar to you. In this post, I’ll show you how to …