Connections
This attribute indicates the upper bound on the number of user-specified concurrent connections to the database.
TimesTen allocates one semaphore for each expected connection. If the number of connections exceeds the value of this attribute, TimesTen returns an error.
The number of current connections to a database can be determined by viewing the output from the ttStatus utility.
As a guideline, set this value to the maximum number of expected application connections plus ten percent.
If you receive an error indicating that the number of connections exceeds the value of this attribute, increase the value until you no longer receive this error.
There is both a fixed and per connection overhead allocated from the PL/SQL segment, even if you do not use PL/SQL. For details, see PLSQL_MEMORY_SIZE.
Note:
The kernel must be configured with enough semaphores to handle all active databases. For details on setting semaphores for your system, see Operating System Prerequisites in Oracle TimesTen In-Memory Database Installation, Migration, and Upgrade Guide or Operating System Prerequisites in Oracle TimesTen In-Memory Database Scaleout User's Guide.
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 Connections as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
The default value is the lesser of Supported value is an integer from |
|
Windows ODBC Data Source Administrator |
Not applicable |