ttOptGetMaxCmdFreeListCnt

This procedure returns the size of the free list of SQL compiled command cache. To reset the size of the cache, use ttOptSetMaxPriCmdFreeListCnt for materialized views and ttOptSetMaxCmdFreeListCnt for regular tables.

Required Privilege

This procedure requires no 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 locally on the element from which it is called.

Related Views

This procedure has these related views.

SYS.GV$OPT_MAX_CMD_FREELIST_CNT

SYS.V$OPT_MAX_CMD_FREELIST_CNT

Syntax

ttOptGetMaxCmdFreeListCnt()

Parameters

ttOptGetMaxCmdFreeListCnt has no parameters.

Result Set

ttOptGetMaxCmdFreeListCnt returns the results.

Column	Type	Description
`retVal`	`TT_VARCHAR (200) NOT NULL`	The size of the SQL compiled command cache.

Example

CALL ttOptGetMaxCmdFreeListCnt();