PLSQL_SESSION_CACHED_CURSORS
This attribute specifies the number of session cursors to cache. A user may adjust the setting to free up space not currently needed in the cache.
PLSQL_SESSION_CACHED_CURSORS can be modified by an ALTER
SESSION SQL statement, described in Oracle TimesTen In-Memory Database
SQL Reference.
ALTER SESSION SET PLSQL_SESSION_CACHED_CURSORS=25;
The value of this connection attribute also can be set at a database level by the ttDBConfig built-in procedure.
Note:
This attribute has the same functionality as SESSION_CACHED_CURSORS in Oracle Database.
Required Privilege
No privilege is required to 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 PLSQL_SESSION_CACHED_CURSORS as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
A positive integer from 1 to 65535 representing the number of cursors to cache. The default value is |
|
Windows ODBC Data Source Administrator |
N/A |