OracleDB exporter metric definition file (metrics_oracledb_exporter.conf)

Organization of this page

Syntax

See Syntax in Node exporter metric definition file (metrics_node_exporter.conf).

To Page Top

File

metrics_oracledb_exporter.conf

metrics_oracledb_exporter.conf.model (model file)

To Page Top

Storage directory

- Integrated manager host

In Windows:

For a physical host

Manager-path\conf\imdd\plugin\jp1pccs\
For a logical host

shared-folder\jp1imm\conf\imdd\plugin\jp1pccs\

In Linux:

For a physical host

/etc/opt/jp1imm/conf/imdd/plugin/jp1pccs/
For a logical host

shared-directory/jp1imm/conf/imdd/plugin/jp1pccs/

To Page Top

Description

This file defines the metric information of OracleDB exporter displayed on the Trends tab, Dashboard tab, and Dashboard List dialog box of the Integrated Operation Viewer window.

Definitions are used for the return values of the __metricListGet method and __timeSeriesDataGet method for JP1/IM - Agent product plug-ins.

If JP1/IM - Manager is in a hierarchical configuration and you want the integrated manager to refer to trend data stored in trend data management database of lower manager, you must add the referenced trend data metrics to the integrated manager metric definition file.

To Page Top

Character encoding

UTF-8 (without BOM)

To Page Top

Linefeed code

In Windows: CR+LF

In Linux: LF

To Page Top

Timing in which definitions are reflected

Definitions are reflected when the metric information is obtained on the Trends tab, Dashboard tab, and Dashboard List dialog box of the Integrated Operation Viewer window, or with the REST API.

To Page Top

Content description

See Content description in Node exporter metric definition file (metrics_node_exporter.conf) in (2. Definition Files) JP1/IM - Agent.

To Page Top

Model file settings (initial status)

The settings (initial status) of each metric described in the model file of the OracleDB exporter metric definition file are shown below.

oracledb_up

■Settings (initial status)

Member name		Settings (initial status)
name		oracledb_up
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		oracledb_up and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	OracleDB Startup Status
	description	Shows the startup status of OracleDB. 1 indicates that it is running, while 0 indicates that it is stopped.
	unit	-

cache_hit_ratio_percent

■Settings (initial status)

Member name		Settings (initial status)
name		cache_hit_ratio_percent
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		(1 - (rate(oracledb_activity_physical_reads_cache[$stepTime{minSeconds=`\`"120`\`"}]) / (rate(oracledb_activity_consistent_gets_from_cache[$stepTime{minSeconds=`\`"120`\`"}])+rate(oracledb_activity_db_block_gets_from_cache[$stepTime{minSeconds=`\`"120`\`"}]))))*100 and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Cache Hit Ratio
	description	Shows the cache hit ratio.
	unit	%

tablespace_used_percent

■Settings (initial status)

Member name		Settings (initial status)
name		tablespace_used_percent
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		oracledb_tablespace_used_percent and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Tablespace Usage
	description	Shows the usage of each tablespace. If automatic extension is ON, it is calculated based on the size considering automatic extension.
	unit	%

execute_count

■Settings (initial status)

Member name		Settings (initial status)
name		execute_count
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		rate(oracledb_activity_execute_count[$stepTime{minSeconds=`\`"120`\`"}])*60 and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	SQL Statement Execution Count
	description	Shows the number of calls to execute SQL statements (user calls and recursive calls).
	unit	-

parse_count

■Settings (initial status)

Member name		Settings (initial status)
name		parse_count
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		rate(oracledb_activity_parse_count_total[$stepTime{minSeconds=`\`"120`\`"}])*60 and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Parsing Call Execution Count
	description	Shows the execution count of parsing calls (hard, soft, and describe).
	unit	-

user_commit_count

■Settings (initial status)

Member name		Settings (initial status)
name		user_commit_count
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		rate(oracledb_activity_user_commits[$stepTime{minSeconds=`\`"120`\`"}])*60 and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Commit Execution Count
	description	Shows the number of user commits.
	unit	-

user_rollback_count

■Settings (initial status)

Member name		Settings (initial status)
name		user_rollback_count
default		true
promql for the metric definition file (including $jp1im_TrendData_labels)		rate(oracledb_activity_user_rollbacks[$stepTime{minSeconds=`\`"120`\`"}])*60 and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Rollback Execution Count
	description	Shows the number of times users issued a ROLLBACK statement manually or the number of errors occurred in user transactions.
	unit	-

resource_used

■Settings (initial status)

Member name		Settings (initial status)
name		resource_used
default		false
promql for the metric definition file (including $jp1im_TrendData_labels)		oracledb_resource_current_utilization and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Resource Usage
	description	Shows the resource usage.
	unit	-

session_count

■Settings (initial status)

Member name		Settings (initial status)
name		session_count
default		false
promql for the metric definition file (including $jp1im_TrendData_labels)		oracledb_sessions_value and $jp1im_TrendData_labels
resource_en	category	database_oracle
	label	Number of Sessions
	description	Shows the number of sessions based on status and type.
	unit	-

To Page Top