ttOptSetMaxPriCmdFreeListCnt
This procedure sets the maximum count of the free list of SQL compiled commands that perform materialized view maintenance.
When this command is set, freeable materialized view compiled commands are counted separately from those of regular tables. If this command is not set, materialized view compiled commands are counted as regular commands.
Required Privilege
This procedure requires the ADMIN privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic.
TimesTen Scaleout applications can call this built-in procedure.
In TimesTen Scaleout, this procedure runs on all elements in the grid.
Related Views
This procedure has no related views.
Syntax
ttOptSetMaxPriCmdFreeListCnt(maxCnt)Parameters
ttOptSetMaxPriCmdFreeListCnt has the required parameter:
| Parameter | Type | Description |
|---|---|---|
|
|
|
The size of the SQL compiled command cache. |
Result Set
ttOptSetMaxPriCmdFreeListCnt returns no results.
Examples
CALL ttOptSetMaxPriCmdFreeListCnt(40);