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.
For TimesTen Scaleout, indicates the size in MB of the permanent memory region for the element.
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.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.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 |
|
|
|
Windows ODBC Data Source Administrator |
Not applicable |