Monitoring Tables

Adaptive Server 15.0.1 introduces two new monitoring tables: monProcedureCacheMemoryUsage and monProcedureCacheModuleUsage.

Monitoring table Description
monProcedureCacheMemoryUsage Has one row for each procedure cache allocator. An allocator is identified by an allocator ID, which is internal to Adaptive Server.
monProcedureCacheModuleUsage. Has one row for each module that allocates memory from procedure cache. A module, which is identified with a module ID, is a functional area classification internal to Adaptive Server procedure cache management.

See the Performance and Tuning Guide: Monitoring and Analyzing and the Reference Manual: Tables.