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.