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.

Related Views

This procedure has this related view.

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();