PermSize

Indicates the size in MB for the permanent partition of the database.

For TimesTen Classic, indicates the size in MB of the permanent memory region for the database.

You may increase PermSize at first connect but not decrease it. TimesTen returns a warning if you attempt to decrease the permanent memory region size. If the database does not exist, a PermSize value of 0 or no value indicates to use the default size. For an existing database, a value of 0 or no value indicates that the existing size should not be changed.

Once you have created a database, you can make the permanent partition larger, but not smaller. See Specifying the Memory Region Sizes of a Database in Oracle TimesTen In-Memory Database Operations Guide.

Also see information about the TempSize connection attribute.

The ttMigrate and ttDestroy utilities can also be used to change the Permanent Data Size, when appropriate.

Required Privilege

Only the instance administrator can change the value of this attribute.

Setting

Set PermSize as follows:

Where to set the attribute	How the attribute is represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen	PermSize	n - Size of permanent partition in megabytes; default is 32 MB.
Windows ODBC Data Source Administrator	Not applicable