PERFORMANCE_COUNTERS

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

PERFORMANCE_COUNTERS

Previous pageReturn to chapter overviewNext page

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

 

5_2_indicator

Version 5.3 Feature

As of version 5.3, you no longer need to use the preface SYS_BOOT.MGMT.

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'