PERFORMANCE_COUNTERS

Returns a table of performance information. Not populated with streams at this point.

returns table(

Field Type
counter_category varchar(128)
counter_subcategory varchar(128)
source_name varchar(128)
counter_name varchar(1024)
counter_units varchar(128)
counter_value varchar(1024)

Syntax

SELECT * FROM TABLE(SYS_BOOT.MGMT.PERFORMANCE_COUNTERS());

Example

SELECT * FROM TABLE(SYS_BOOT.MGMT.PERFORMANCE_COUNTERS());
'COUNTER_CATEGORY','COUNTER_SUBCATEGORY','SOURCE_NAME','COUNTER_NAME','COUNTER_UNITS','COUNTER_VALUE'
'JVM Memory','','JVM','JvmMemoryUnused','bytes','134338560'
'JVM Memory','','JVM','JvmMemoryAllocationLimit','bytes','2077753344'
'JVM Memory','','JVM','JvmMemoryAllocated','bytes','192139264'