PL/SQL Database Configuration Parameters
You can use the ttDBConfig
built-in procedure to display or set the values of the database configuration parameters PLSQL_OPEN_CURSORS
and PLSQL_SESSION_CACHED_SURSORS
.
Using ttDBConfig
sets the value for the current connection and future connections. For information about these parameters, which are also available as connection attributes, see PL/SQL Connection Attributes Reference.
For example, to retrieve the current value of PLSQL_OPEN_CURSORS
:
call ttdbconfig('PLSQL_OPEN_CURSORS');
< PLSQL_OPEN_CURSORS, 50 >
1 row found.
To set the value to 75:
call ttdbconfig('PLSQL_OPEN_CURSORS', '75');
< PLSQL_OPEN_CURSORS, 75 >
1 row found.
Refer to ttDBConfig in Oracle TimesTen In-Memory Database Reference.