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.
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 |