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 …
Category: 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: Danny: > ttisqlcs Copyright …
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) There are 11 connections to the data store Shared Memory KEY 0x0c0504dd ID 1838710795 (LOCKED) …
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 …
