HOWTO : Understand Modifying TimesTen PermSize And TempSize First Connect Database Attributes (Doc ID 1081008.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 7.0.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Jan-2012***

PermSize And TempSize First Connect Database Attributes
Warning 6226: Ignoring value requested for first connection attribute
Warning 6200: New value for permanent data partition size ignored since smaller than current value
15019: Only the instance admin may alter the PermSize attribute


Goal

Demonstrate how to modify the TimesTen PermSize and TempSize.

Notes:

There are two methods to modify PermSize and TempSize
1. Change the DSN attributes (PermSize, TempSize) or
2. Specify values in the connection string attributes (PermSize, TempSize). Values in the connection string
    take precedence over those in the DSN definition.

Increasing PermSize and TempSize or decreasing TempSize only requires a reload of the database with some caveats related to OS settings:
It has a prerequisite that you need enough ram and the size of shared memory has to be sized enough to accommodate any increase made kernel.shmmax and kernel.shmall in /etc/sysctl.conf, see TimesTen Installation Guide, "Shared Memory".

If you are using huge pages that may also have to be adjusted for any increase in size:
vm.nr_hugepages in /etc/sysctl.conf, see TimesTen Installation Guide, "Large Pages".

Decreasing PermSize requires recreating the database.  For details on how to decrease PermSize, please read Note 1081032.1.

PermSize change since it it saved to disk requires the user making the connection to be the instance admin.

Solution

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