ttOptGetMaxCmdFreeListCnt

Description

Returns the size of the SQL compiled command cache. To reset the size of the cache, use ttOptSetMaxPriCmdFreeListCnt for regular tables and ttOptSetMaxCmdFreeListCnt for materialized views.

Required privilege

This procedure requires no privilege.

Parameters

ttOptGetMaxCmdFreeListCnt has no parameters.

Syntax

ttOptGetMaxCmdFreeListCnt()

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